Re: pgsql: Make VACUUM avoid waiting for a cleanup lock, where possible.

On 8 November 2011 02:46, Robert Haas <rhaas(at)postgresql(dot)org> wrote:
> Make VACUUM avoid waiting for a cleanup lock, where possible.
>
> In a regular VACUUM, it's OK to skip pages for which a cleanup lock
> isn't immediately available; the next VACUUM will deal with them.  If
> we're scanning the entire relation to advance relfrozenxid, we might
> need to wait, but only if there are tuples on the page that actually
> require freezing.  These changes should greatly reduce the incidence
> of of vacuum processes getting "stuck".

Minor comment typo but a typo nonetheless:

It's OK to skip vacuuming a page, as long as its not got data

Should be:

It's OK to skip vacuuming a page, as long as it's not got data

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company