okay back after the VACUUM FULL:
database size is back down to 1574 MB from ~4GB
@staticsafe wow that's a lot
@staticsafe 20 -> 8GB for me. Also what is the munin plugin you use?
lrwxrwxrwx 1 root root 39 May 7 02:23 postgres_size_ALL -> /usr/share/munin/plugins/postgres_size_
lrwxrwxrwx 1 root root 47 May 7 02:24 postgres_transactions_ALL -> /usr/share/munin/plugins/postgres_transactions_
It came with the Munin install on Ubuntu 16.04
@staticsafe thanks :)
@staticsafe mhhh how do you vacuum ?
@dashie psql -d mastodon_production -c "VACUUM FULL"
did that from the mastodon user
@staticsafe oh, well ok, simple as that :D
@staticsafe thanks !
staticsafe's personal Mastodon instance.