Re: CLUSTER equivalent

Поиск
Список
Период
Сортировка
От Kevin Murphy
Тема Re: CLUSTER equivalent
Дата
Msg-id 4329E31F.3060403@genome.chop.edu
обсуждение исходный текст
Ответ на Re: CLUSTER equivalent  (Neil Conway <neilc@samurai.com>)
Ответы Re: CLUSTER equivalent  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: character varying == text?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: CLUSTER equivalent