SQL Server index updates vs PostgreSQL index updates

The link below is to quite a fascinating article that on the surface is about why Uber moved to MySQL from PostgreSQL.

What it really is about is a severe limitation in how PostgreSQL indexes are updated.

With SQL Server, if you update a few columns in a row, only the indexes that have that column are updated. In PostgreSQL, all indexes still need to be updated. I understand why they’ve done that but it’s not a good outcome.

SQL Server shines in this regard.

http://use-the-index-luke.com/blog/2016-07-29/on-ubers-choice-of-databases

2016-08-04