From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | pg_autovacuum integration patch |
Date: | 2004-06-16 06:19:12 |
Message-ID: | 1087366752.6330.21.camel@zedora2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Ok, I have an 1st cut patch for pg_autovacuum integration into the
backend. Please apply this patch to CVS or at least review and let me
know what I need to change to get it applied to CVS.
This patch requires that pg_autovacuum.c and .h are moved from contrib
to src/backend/postmaster and src/include/postmaster respectively. I
have also attached the pg_autovacuum.h file that needs to be put in
src/include/catelog/ for the new pg_autovacuum system table.
There is more to do for pg_autovacuum but I would like to get this patch
included into CVS or at least get it rejected now so I can fix it before
July 1.
With this patch pg_autovacuum:
* is a postmaster subprocess modeled after the bgwriter
* uses elog for all output (I guessed at the appropriate elog levels)
* used a new GUC variable to enable and disable pg_autovacuum
* stores all it's volitile data in a new pg_autovacuum system table
* allows admin to set per table thresholds
Matthew O'Connor
Attachment | Content-Type | Size |
---|---|---|
diff | text/x-patch | 63.9 KB |
pg_autovacuum.h | text/x-chdr | 3.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Laurent Ballester | 2004-06-16 07:25:44 | Re: eventlog fix |
Previous Message | Bruce Momjian | 2004-06-16 02:50:03 | Re: Fix for erroneous warning on Shutdown |