Hot answers tagged


VACUUM only affects the size of physical backups (pg_basebackup, etc), not logical backups (dumps). You don't need to. There's no such thing as too much VACUUM. It's harmless. You shouldn't need manual VACUUM though, just make sure autovacuum is enabled and set to run enough. I strongly advise that you use point-in-time recovery as well as logical backups ...

Only top voted, non community-wiki answers of a minimum length are eligible