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...5/msg00704.php
plus a small change to make it work for simple ANALYSE too.

--
Hannu Krosing <hannu@skype.net>


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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...5/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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly