Thread: patch for pg_autovacuum
here's a patch that joins on pg_class.oid instead of pg_class.relfilenode, also i have renamed the table structure from relfilenode to relid.
Attachment
Brian Hirt wrote: > here's a patch that joins on pg_class.oid instead of > pg_class.relfilenode, also i have renamed the table structure from > relfilenode to relid. I can't test this patch right now, but I know when I wrote pg_autovacuum I didn't test for table truncate, so it sound logical. From eyeballing the patch it looks correct. Brian, you might want to post this to the pgsql-patches list.
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Brian Hirt wrote:
> here's a patch that joins on pg_class.oid instead of
> pg_class.relfilenode, also i have renamed the table structure from
> relfilenode to relid.
>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
--
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
Bruce, for what it's worth, Matthew O'Connor submitted a patch which includes my patch. best regards, Brian Hirt. On Nov 29, 2003, at 10:14 PM, Bruce Momjian wrote: > [ Attachment, skipping... ]
Patch applied. Thanks. --------------------------------------------------------------------------- Brian Hirt wrote: > here's a patch that joins on pg_class.oid instead of > pg_class.relfilenode, also i have renamed the table structure from > relfilenode to relid. > [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- 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
Also applied to 7.4.X. --------------------------------------------------------------------------- Brian Hirt wrote: > here's a patch that joins on pg_class.oid instead of > pg_class.relfilenode, also i have renamed the table structure from > relfilenode to relid. > [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- 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