Skip site navigation (1) Skip section navigation (2)

PATCH to allow concurrent VACUUMs to not lock each other out fromcleaning 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 fromcleaning old tuples
Date: 2005-05-18 08:54:05
Message-ID: 1116406445.4809.20.camel@fuji.krosing.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: vacuum-patch.diff
Description: text/x-patch (5.9 KB)

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group