Re: Skipping VACUUM of indexes when no work required - Mailing list pgsql-patches

From Tom Lane
Subject Re: Skipping VACUUM of indexes when no work required
Date
Msg-id 27701.1139693763@sss.pgh.pa.us
Whole thread Raw
In response to Re: Skipping VACUUM of indexes when no work required  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Skipping VACUUM of indexes when no work required
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Skipping VACUUM of indexes when no work required
Next
From: Bruce Momjian
Date:
Subject: Re: TODO item -- Improve psql's handling of multi-line