Scott Marlowe <scott.marlowe@xxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance