Re: CLUSTER and synchronized scans and pg_dump et al

Kevin Grittner wrote:
>>>> On Sun, Jan 27, 2008 at  9:02 AM, in message
>>>>         
> <87odb7s45i.fsf@oxford.xeocode.com>, Gregory Stark <stark@enterprisedb.com>
> wrote: 
>  
>   
>> Perhaps we should have some form of escape hatch for pg_dump to request real
>> physical order when dumping clustered tables.
>>     
>  
> It would seem reasonable to me for pg_dump to use ORDER BY to select
> data from clustered tables.
>  
> I don't see a general case for worrying about the order of rows
> returned by queries which lack an ORDER BY clause.
>  
>
>   

What will be the performance hit from doing that?

cheers

andrew