Re: Skipping VACUUM of indexes when no work required

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Skipping VACUUM of indexes when no work required
Date: 2006-02-11 19:42:48
Message-ID: 1139686968.1258.605.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Sat, 2006-02-11 at 12:04 -0500, Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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.

The patch skips only the first scan, not the second phase which does the
post-cleanup. We discussed this before and I listened...

I believe this is safe.

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Simon Riggs 2006-02-11 19:47:32 Re: Scrollable cursors and Sort performance
Previous Message Tom Lane 2006-02-11 17:53:18 Re: Skipping VACUUM of indexes when no work required