Re: "Healing" a table after massive updates

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: "Healing" a table after massive updates
Дата
Msg-id 20080911144100.GC9492@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: "Healing" a table after massive updates  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: "Healing" a table after massive updates
Список pgsql-general
Bill Moran wrote:
> In response to "Gauthier, Dave" <dave.gauthier@intel.com>:
>
> > I might be able to answer my own question...
> >
> > vacuum FULL (analyze is optional)
>
> CLUSTER _may_ be a better choice, but carefully read the docs regarding
> it's drawbacks first.  You may want to do some benchmarks to see if it's
> really needed before you commit to it as a scheduled operation.

What drawbacks?

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

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: "Healing" a table after massive updates
Следующее
От: Bill Moran
Дата:
Сообщение: Re: "Healing" a table after massive updates