Re: Skipping VACUUM of indexes when no work required

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Skipping VACUUM of indexes when no work required
Дата
Msg-id 1139749937.1258.623.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Sat, 2006-02-11 at 16:36 -0500, Tom Lane wrote:
> 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.

I don't recall either way, though from what you say it seems I did not
test those cases. Thanks for catching my error.

> 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...

Thanks for spotting this case. I strive to learn.

Best Regards, Simon Riggs



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: parallel builds with dependencies
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: psql tab completion enhancements