Re: Skipping VACUUM of indexes when no work required

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Skipping VACUUM of indexes when no work required
Дата
Msg-id 27701.1139693763@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Skipping VACUUM of indexes when no work required  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Skipping VACUUM of indexes when no work required  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Simon Riggs <simon@2ndquadrant.com> writes:
> I believe this is safe.

I won't insult your intelligence by pointing out how I know that you
didn't even test the patch against hash or gist.

The major problem with the patch is that it's incapable of producing
correct tuple-count stats for partial indexes, which is really not
acceptable from a planning standpoint.  What I'm currently fooling with
is skipping the bulkdelete scan only if the index isn't partial...

            regards, tom lane

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Skipping VACUUM of indexes when no work required
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: TODO item -- Improve psql's handling of multi-line