PATCH to allow concurrent VACUUMs to not lock each other out from cleaning old tuples - Mailing list pgsql-patches

From Hannu Krosing
Subject PATCH to allow concurrent VACUUMs to not lock each other out from cleaning old tuples
Date
Msg-id 1116406445.4809.20.camel@fuji.krosing.net
Whole thread Raw
Responses Re: PATCH to allow concurrent VACUUMs to not lock each  (Hannu Krosing <hannu@skype.net>)
Re: PATCH to allow concurrent VACUUMs to not lock each  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
The attached patch allows VACUUMS's on small relations to clean up dead
tuples while VACUUM or ANALYSE is running for a long time on some big
table.

This is done by adding a "bool inVacuum" to PGPROC and then making use
of it in GetOldestXmin.

This patch is against current CVS head, but should also apply to 8.0.2
with minorpach  warnings.

--
Hannu Krosing <hannu@tm.ee>

Attachment

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: Bunch of tab-completion enhancements for psql
Next
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] read-only database