Re: : Performance Improvement Strategy - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: : Performance Improvement Strategy
Date
Msg-id CAOR=d=1HNVVnsADVngt+Kj7L0rpyCfyvL5oLkxOj7jsq9ZVcqg@mail.gmail.com
Whole thread Raw
In response to Re: : Performance Improvement Strategy  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: : Performance Improvement Strategy  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-performance
On Wed, Oct 5, 2011 at 12:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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)

Looks like I owe Leonardo Francalanci a pizza.

pgsql-performance by date:

Previous
From: Raghavendra
Date:
Subject: Re: : Performance Improvement Strategy
Next
From: "mark"
Date:
Subject: Re: pg9 replication over WAN ?