so, my 36.9GiB postgres database produces and 25.4GiB dump file that compresses to 3.6GiB with gzip
why so much bloat!?
@dirb Compression is most effective when the input contains repetitive data. I haven't looked at pleroma's db schema yet, but it's obvious that most of it is repeated usernames and urls.
@dirb That's because dumps don't include index data, they'll be created when you restore the dump.
