News for hackers. Stuff that matters.
Re:Showdown: MySQL 8 vs. PostgreSQL 10 by nvivo on Wednesday May 23, 2018 @01:31PM (#17136081)
I think it's different. From the docs, this is a one time update to the table. The table itself is not clustered, it's just ordered based on a clustered index, so selects by default should come in that order. But once an insert is done, it's again ouy of order.

Also, an order by using the cluster field most probably invokes an index scan, while a clustered table doesn't.

There are no comments on this comment yet.