Embed Notice
HTML Code
Corresponding Notice
- Embed this notice@phnt
>Not sure about the "I just restored all the DB files from a backup I made at the start of the maintenance" part, since if it was a simple tar/whatever based backup, all the bloat in the files is still there.
yeah I just rsync it to a directory on the slab. there might be a lot of cruft :013_thumbs_up:
>If you don't have enough disk space for a full vacuum of the database (in your case probably around 1.7x of the current size of the DB),
I already worked around this in the past. move everything to the slab and vacuum the tables one by one
>If the number of activities is still the same, it probably didn't even resolve the ones to delete yet.
I'm afraid that is the case and I've waited for naught. the reads and writes, incl. slab, have probably misled me
>I just use \l+ in psql for size of databases and \dt+ and \di+ for table and index sizes respectively since it's a quick and dirty command.
cool, I didn't know. thanks! :013_thumbs_up: