Re: Skipping VACUUM of indexes when no work required

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Skipping VACUUM of indexes when no work required
Дата
Msg-id 9659.1139680398@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Skipping VACUUM of indexes when no work required  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Simon Riggs <simon@2ndquadrant.com> writes:
> We discussed an optimization of VACUUM here
> http://archives.postgresql.org/pgsql-hackers/2005-09/msg00046.php
> that would allow VACUUM to complete faster by avoiding scanning the
> indexes when no rows were removed from the heap by the VACUUM.

After looking at this, I think it is salvageable, but the patch as
written complicates the vacuum-to-index-AM API more than necessary;
there's no reason why the AM has to expose the fact that it skipped
doing anything.

I'll clean it up and reapply.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Allow VACUUM to complete faster by avoiding
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Skipping VACUUM of indexes when no work required