How to Cluster an Index live?

Поиск
Список
Период
Сортировка
От Siah
Тема How to Cluster an Index live?
Дата
Msg-id 1184431483.653185.134470@22g2000hsm.googlegroups.com
обсуждение исходный текст
Ответы Re: How to Cluster an Index live?
Список pgsql-general
Hi,

How can I have my table clustered as records are being insert/updated
(per transaction).

I tried doing so with creating an index using pgAdmin III, and it
generated the following SQL:

CREATE INDEX someindex ON mytable (m2);
ALTER TABLE mytable CLUSTER ON someindex;

Now, above DID NOT cluster my table and I had to run PostgreSQL's own
cluster command to have it clustered. According to my db-savvy
colleagues (who use SQL Server), a live cluster is a must have on a
high traffic large db and they are questioning this feature of
PostgreSQL.

I'd appreciate comments here,
Thanks,
Mike


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