Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: CLUSTER and synchronized scans and pg_dump et al
Date
Msg-id 479D988B.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to CLUSTER and synchronized scans and pg_dump et al  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: CLUSTER and synchronized scans and pg_dump et al  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view 
>>> 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.
-Kevin

pgsql-hackers by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: CLUSTER and synchronized scans and pg_dump et al
Next
From: Andrew Dunstan
Date:
Subject: Re: CLUSTER and synchronized scans and pg_dump et al