Thread with 1 post
jump to expanded post
Bleh, an hour of downtime, almost 25 minutes of sqlite3 file 'VACUUM' and my@gotosocial@superseriousbusiness.org #sqlite database still only went from 6.2GB to 5.5GB.
I mean, it's not nothing, but I expected more. Why the hell in the first place does a single-user instance need 5.5GB in the database? I have 3.3GB of media alongside the database, why do I have more text then media? Does GoToSocial save some blobs in the database?
Would switching to Postgres make the database smaller?
Or is this merely a matter of distributed systems, I have a lot of redundant data?
If anybody has even a link to an issue discussing this or something it would be really helpful. I tried searching, but no luck. If I make the time, I'ma copy over the database file locally and try to look into it.