Re: Skipping VACUUM of indexes when no work required

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Skipping VACUUM of indexes when no work required
Дата
Msg-id 1139686968.1258.605.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Sat, 2006-02-11 at 12:04 -0500, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Patch applied.  Thanks.
>
> Please revert.  You cannot skip scanning indexes simply because there
> was no heap activity.  btree for instance does post-cleanup on the
> next vacuum.

The patch skips only the first scan, not the second phase which does the
post-cleanup. We discussed this before and I listened...

I believe this is safe.

Best Regards, Simon Riggs


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Skipping VACUUM of indexes when no work required
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Skipping VACUUM of indexes when no work required