Postgres Pro
Downloads
Home   >   mailing lists

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 8659.1139677450@sss.pgh.pa.us
Whole thread Raw
In response to Re: Skipping VACUUM of indexes when no work required  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Skipping VACUUM of indexes when no work required  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-patches
Tree view 
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.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Skipping VACUUM of indexes when no work required
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Allow VACUUM to complete faster by avoiding