Hacker News new | ask | show | jobs
by api 2062 days ago
The whole VACUUM paradigm is the biggest thing that bugs me about pgsql. The fact that it can actually freeze things always worries me. Can’t this happen constantly in the background like modern GCs?
2 comments
spacemanmatt 2062 days ago
I think you might be pleasantly surprised to get current on how vacuum works in current editions. Vacuum used to be a bigger issue for pg.
link
chousuke 2062 days ago
It does, though? That's what autovacuum is, unless I'm missing something.

It's just not always enough without tuning, just like GC.

link
api 2062 days ago
We have had a lot of problems with frequently updated tables. Is auto tuning really that hard? Or is pg’s philosophy not to “auto” anything?
link