{"p":"","h":{"iv":"ROXSYW+cfvEbFHu5","at":"ocxplSQjdRC3tXEtB/9/wg=="}}

I used to run VACUUM on my DB regularly, but I read multiple places that it's not recommended for postgres 12 because it now basically auto-vacuums? I guess? Can you tell I don't understand much about postgres??

3
Share
Share on Mastodon
Share on Twitter
Share on Facebook
Share on Linkedin

@darius unless you have special needs, let PostgreSQL do its own thing.

0
2y
oberhamsi

@darius you can config the auto vacuum but unless you need or do something special (eg big import or delete) it works well

0
2y
Maybe it's Eyesaline

@darius autovacuum has been a thing for years. If you're running production stuff on postgres, I strongly recommend that you disable autovacuum and run it manually on a schedule, during off-peak hours.

Thing about auto VACUUM is that postgres can decide to do it whenever. And if that's peak hours, the overhead of it will tank performance and can take down production.

0
2y
Replies