Re: "vacuum" and "cluster"

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: "vacuum" and "cluster"
Дата
Msg-id 20080416192733.GC7942@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: "vacuum" and "cluster"  ("Jimmy Choi" <yhjchoi@gmail.com>)
Список pgsql-general
Jimmy Choi escribió:
> Presumably, even if CLUSTER does reindexing internally, it only does
> that for the index used for clustering. Since REINDEX includes all
> indices, CLUSTER cannot truly replace REINDEX. Correct?

No.  Cluster rewrites all indexes (otherwise their entries would end up
pointing to incorrect places in the heap.)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: "David Wilson"
Дата:
Сообщение: Re: table as log (multiple writers and readers)
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Storage sizes for dates/times (documentation bug?)