Postgres Pro
Downloads
Home   >   mailing lists

Re: CLUSTER and synchronized scans and pg_dump et al - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CLUSTER and synchronized scans and pg_dump et al
Date
Msg-id 3001.1201538162@sss.pgh.pa.us
Whole thread Raw
In response to Re: CLUSTER and synchronized scans and pg_dump et al  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: CLUSTER and synchronized scans and pg_dump et al  (Steve Atkins <steve@blighty.com>)
Re: CLUSTER and synchronized scans and pg_dump et al  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Tree view 
Andrew Dunstan <andrew@dunslane.net> writes:
> Kevin Grittner wrote:
>> It would seem reasonable to me for pg_dump to use ORDER BY to select
>> data from clustered tables.

> What will be the performance hit from doing that?

That worries me too.  Also, in general pg_dump's charter is to reproduce
the state of the database as best it can, not to "improve" it.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: system catalog constraints question
Next
From: Tom Lane
Date:
Subject: Re: GSSAPI doesn't play nice with non-canonical host names