Email or username:

Password:

Forgot your password?
Darius's posts Post Back to profile
Top-level
Darius Kazemi

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??

19 Nov 2022 at 18:13 | Open on friend.camp
3 comments
DELETED

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

19 Nov 2022 at 18:23 | Open on social.emily.news
oberhamsi

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

19 Nov 2022 at 18:40 | Open on wien.rocks
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.

19 Nov 2022 at 20:09 | Open on mastodon.social
Go Up