Hannu Krosing wrote: > On K, 2005-05-18 at 11:54 +0300, Hannu Krosing wrote: > > 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. > > Could this patch be applied (or rejected if something is badly wrong > with it) ? > > Or should I move the discussion back to pgsql-hackers ad try to make it > a TODO first ? > > This patch implements what I described in > http://archives.postgresql.org/pgsql-hackers/2005-05/msg00704.php > plus a small change to make it work for simple ANALYSE too.
I have it in my mailbox and will get to it. Thanks. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly