On 8 November 2011 02:46, Robert Haas <[email protected]> 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 -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
