4 ms·
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
by fuhrysteve 6y 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%40agliodbs.com https://www.postgresql.org/message-id/5797D5A1.5030009%40agl...
- api 6y agoThe 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?
- chousuke 6y agoIt does, though? That's what autovacuum is, unless I'm missing something. It's just not always enough without tuning, just like GC.
- api 6y agoWe 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?
- spacemanmatt 6y agoI 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.