News for hackers. Stuff that matters.

A comment on At 22 years old, Postgres might just be the most advanced database yet. Parent comment

Re:At 22 years old, Postgres might just be the most advanced... by panarky on Wednesday December 05, 2018 @08:11PM (#18614499)
> just switch SQL Server to MVCC

In the real world of mediocre DBAs and databases managed by application vendors, it's never that easy, is it?

Postgres just works with default settings while SQL Server chokes on the same transactions with the same volumes.

SQL Server is legendary [0] for deadlocks even when the workload is mostly reads and rarely writes. You just don't see this with Oracle, Postgres or MySQL with default settings.

Not sure why I'd pay for the privilege of extra headaches.

[0] It was a problem in 2008, still not resolved https://blog.codinghorror.com/deadlocked/

[ Parent | on HN ]
Re:At 22 years old, Postgres might just be the most advanced... by manigandham on Friday December 07, 2018 @07:15PM (#18632864)
Yes the defaults are more pessimistic but why is such a problem to change the locking level?

SQL Server has one of the most advanced query optimizers. Are you running on an old version or using out of date statistics?

[ Parent | on HN ]