CLUSTER equivalent - Mailing list pgsql-general

From Kevin Murphy
Subject CLUSTER equivalent
Date
Msg-id 4329C008.3010500@genome.chop.edu
Whole thread Raw
Responses Re: CLUSTER equivalent
List pgsql-general
I just wanted to confirm that the COPY command always stores data in the
table in the order in which it appears in the import file.

I.e., if the import file is sorted ahead of time, am I correct in
assuming that the COPY command can have the same effect as CLUSTER'ing
(or as creating a new table as an ordered select on the loaded table)?
(Indexes would of course be applied after the data load.)

Thanks,
Kevin Murphy


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to check is the table system
Next
From: Martijn van Oosterhout
Date:
Subject: Re: How to check is the table system