On Wed, Oct 5, 2011 at 12:15 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Scott Marlowe <scott.marl...@gmail.com> 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)
Looks like I owe Leonardo Francalanci a pizza. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
