Re: CLUSTER equivalent

From: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Cc: Neil Conway <neilc(at)samurai(dot)com>
Subject: Re: CLUSTER equivalent
Date: 2005-09-15 21:09:51
Message-ID: 4329E31F.3060403@genome.chop.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-09-15 21:35:05 Re: CLUSTER equivalent
Previous Message Tom Lane 2005-09-15 21:07:46 Re: character varying == text?