pg_autovacuum integration patch

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

Browse pgsql-patches by date

  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