Re: CLUSTER equivalent - Mailing list pgsql-general

From Kevin Murphy
Subject Re: CLUSTER equivalent
Date
Msg-id 4329E31F.3060403@genome.chop.edu
Whole thread Raw
In response to Re: CLUSTER equivalent  (Neil Conway <neilc@samurai.com>)
Responses Re: CLUSTER equivalent
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: character varying == text?
Next
From: Alvaro Herrera
Date:
Subject: Re: CLUSTER equivalent