Re: Proposed patch: Smooth replication during VACUUM FULL

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Proposed patch: Smooth replication during VACUUM FULL
Дата
Msg-id BANLkTim9XMN=U-8NRp9TYDbhrz3m-qd2ug@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposed patch: Smooth replication during VACUUM FULL  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On Mon, May 2, 2011 at 5:20 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Yeah, it would help during the initial scan
>> of the old rel, but not during the sort or reindex steps.
>
> As Greg points out, the sort is not really of concern (for now).

Though I was surprised the reindex isn't an equally big problem. It
might matter a lot what the shape of the schema is. If you have lots
of indexes the index wal might be larger than the table rebuild.

-- 
greg


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Copy/paste from psql - was: Changing the continuation-line prompt in psql?
Следующее
От: Gabriele Bartolini
Дата:
Сообщение: Re: Proposed patch: Smooth replication during VACUUM FULL