Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by sroussey on Thursday May 08, 2025 @10:56AM (#43926689)

On commercial databases from Oracle and Microsoft, you can cluster the DB on any index. Really would love for Postresql to do the same.

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by cwbriscoe on Thursday May 08, 2025 @02:12PM (#43929365)

You can but new rows will not be clustered until you re-cluster.

CLUSTER table_name USING index_name;

[ Parent | on HN ]

Re:Waiting for Postgres 18: Accelerating Disk Reads with Asy... by sroussey on Saturday May 10, 2025 @04:05PM (#43948513)

I remember that for MySQL MyISAM (syntax was different) in the olden days. I thought Oracle let you do it though. My bad.

MySQL Innodb and other have real clustered primary key indexes with all the pluses and minuses that entails.

[ Parent | on HN ]