Hacker News Reader

I wish PostgreSQL had real clustered index like MS SQL and MySQL, not a readonly version that has to be rebuilt after mutation.

View on HN

Effectively you can now do this; a PK index + INCLUDE all other columns in the table. This will be kept upto date without any need for manual reclustering.

Sure it's duplicating the table data, but it's functionally equivalent to the reclustering or rematerialising a view of the table methods that people use now, just without the hassle.

That's a lot worse performance-wise than a clustered index that is at the same time the primary ordering for the table.

True, but MSSQL style clustering has it's own performance trade-offs in terms of slower writes, fillfactor bloat etc.

It's not going to be slower vs an unordered heap + a separate index that includes all the columns. Hence MS SQL implementation is superior. If you don't want a PK, then MS SQL offers you an undordered option.

Reply on news.ycombinator.com