Re: : Performance Improvement Strategy

Scott Marlowe <scott.marlowe@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)

            regards, tom lane