Re: Visibility map, partial vacuums

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