Scott Marlowe <[email protected]> writes:
> It used to be that cluster on a very randomly ordered table was much
> slower than doing something like select * into newtable from oldtable
> order by col1, col2; Is that still the case in 9.0/9.1?
Fixed in 9.1, per release notes:
* Allow CLUSTER to sort the table rather than scanning the index when
it seems likely to be cheaper (Leonardo Francalanci)
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance