Re: Loss of cluster status

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Loss of cluster status
Дата
Msg-id 20030223185149.Q3637-100000@houston.familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Loss of cluster status  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> >> Would it be an idea to issue a CLUSTER command after the CREATE TABLE
> >> statement in SQL dumps for tables that have an indisclustered index?
>
> Yeah...

<snip>

> A CLUSTER command issued just after table creation, while it's
still
> empty, would be cheap ... but we don't put the index in place until
> we've loaded the data, do we?  Darn.

CREATE CLUSTERED INDEX ...?

Chris




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump / restore of empty database gives errors
Следующее
От: Ian Barwick
Дата:
Сообщение: Linking to "current" docs