One word in PostgreSQL unlocked a 9x performance improvement

Re:One word in PostgreSQL unlocked a 9x performance improvement by nicoburns on Sunday June 14, 2020 @01:03PM (#23519319)

> IMO this is the "obvious" behavior, but it is still worthwhile to know it works!

I think this is why people love Postgres so much. 99 times out of 100, the "obvious" behaviour turns out to be the behaviour that Postgres actually implements.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by egeozcan on Sunday June 14, 2020 @01:56PM (#23519730)

But your battle-trained mined, injured from weird RDBMSs, is always expecting the worst, and you still open the docs, searching for the gotcha.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by teraku on Sunday June 14, 2020 @03:02PM (#23520342)

Or like my colleagues: find behaviour that 99 out of 100 db-people find intuitive weird because it's not like WhAt ThEy ArE uSeD tO

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by dkersten on Sunday June 14, 2020 @06:08PM (#23521786)

What are they used to?

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by fphhotchips on Sunday June 14, 2020 @06:33PM (#23521952)

Depends on the industry segment, but I find that MySQL/MariaDB users tend to be the worst for this.

All the RDBMS systems are guilty of it to some degree though.

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by teraku on Monday June 15, 2020 @06:28AM (#23525835)

Oracle

[ Parent | on HN ]

Re:One word in PostgreSQL unlocked a 9x performance improvement by alexbanks on Sunday June 14, 2020 @03:03PM (#23520348)

The actual Python "pit of success" is postgres.

[ Parent | on HN ]