I'm on a private instance. My lemmy volume as a whole is currently 72G.

5 is probably a bit undersized and liable to cause pool timeouts. But like 15 should give you enough room depending on your provider's affordability. You can always delete old data periodically.