Thread: CLUSTER equivalent
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
Kevin Murphy wrote: > 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. This is not the case -- depending on the content of the FSM, the newly added rows might be distributed throughout the table. -Neil
Neil Conway wrote: > Kevin Murphy wrote: > >> 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. > > > This is not the case -- depending on the content of the FSM, the newly > added rows might be distributed throughout the table. How about for a freshly created, empty table -- I should have qualified my original statement. Thanks, Kevin
On Thu, Sep 15, 2005 at 05:09:51PM -0400, Kevin Murphy wrote: > Neil Conway wrote: > > >Kevin Murphy wrote: > > > >>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. > > > >This is not the case -- depending on the content of the FSM, the newly > >added rows might be distributed throughout the table. > > How about for a freshly created, empty table -- I should have qualified > my original statement. In that particular case, the answer is yes. As is if you TRUNCATE the table just prior to the COPY. -- Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com "El destino baraja y nosotros jugamos" (A. Schopenhauer)