I’ve got a site with 1.6M posts and 25K users. The database dump is about 8.7GB, which takes up 22GB of space in Postgres. I generally scoff at people whining about deleting this or that to save space in the database, but 22GB for 1.6M posts seems like a lot.
I upgraded to PG 10, dumped and restored the database, thinking that might help, but it didn’t. I think that this may have started on RDS before I moved it to Digital Ocean, if that provides some clue.
Does this seem normal? Is there some place I could look to see if there’s something bizarre in there?