What’s so exciting about Postgres?

Re:What’s so exciting about Postgres? by api on Friday October 30, 2020 @06:37PM (#24947520)

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?

[ Parent | on HN ]

Re:What’s so exciting about Postgres? by spacemanmatt on Saturday October 31, 2020 @06:28AM (#24950277)

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.

[ Parent | on HN ]

Re:What’s so exciting about Postgres? by chousuke on Friday October 30, 2020 @07:11PM (#24947727)

It does, though? That's what autovacuum is, unless I'm missing something.

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

[ Parent | on HN ]

Re:What’s so exciting about Postgres? by api on Saturday October 31, 2020 @08:06AM (#24950745)

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?

[ Parent | on HN ]