Re: Visibility map, partial vacuums - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Visibility map, partial vacuums
Date
Msg-id 1227471538.7370.14.camel@jdavis-laptop
Whole thread Raw
In response to Re: Visibility map, partial vacuums  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Visibility map, partial vacuums  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, 2008-11-23 at 14:05 -0500, Tom Lane wrote:
> A possible problem is that if a relation is filled all in one shot,
> autovacuum would trigger a single vacuum cycle on it and then never have
> a reason to trigger another; leading to the bits never getting set (or
> at least not till an antiwraparound vacuum occurs).  We might want to
> tweak autovac so that an extra vacuum cycle occurs in this case.  But
> I'm not quite sure what a reasonable heuristic would be.
> 

This would only be an issue if using the visibility map for things other
than partial vacuum (e.g. index-only scan), right? If we never do
another VACUUM, we don't need partial vacuum.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Cool hack with recursive queries
Next
From: Andrew Dunstan
Date:
Subject: Re: Logging auto_explain outputs to another log file