Hacker News new | ask | show | jobs
by fuhrysteve 2062 days ago
Great practical note by Josh Berkus on why Uber left Posgresql. Basically: runaway table bloat because Uber had a usecase that postgres doesn't address as well as InnoDB.

https://www.postgresql.org/message-id/5797D5A1.5030009%40agl...
1 comments
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?
link
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