PATCH to allow concurrent VACUUMs to not lock each other out from cleaning old tuples

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: pgsql-patches(at)postgresql(dot)org
Subject: PATCH to allow concurrent VACUUMs to not lock each other out from cleaning old tuples
Date: 2005-05-18 08:54:05
Message-ID: 1116406445.4809.20.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(at)tm(dot)ee>

Attachment Content-Type Size
vacuum-patch.diff text/x-patch 5.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-05-18 08:54:46 Re: Learning curves and such (was Re: pgFoundry)
Previous Message Mark Cave-Ayland 2005-05-18 08:23:30 Re: Cost of XLogInsert CRC calculations

Browse pgsql-patches by date

  From Date Subject
Next Message Hannu Krosing 2005-05-18 10:07:27 Re: [HACKERS] read-only database
Previous Message Neil Conway 2005-05-18 04:47:57 Re: Bunch of tab-completion enhancements for psql