Re: pg_autovacuum integration attempt #2

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_autovacuum integration attempt #2
Date: 2004-07-12 07:14:20
Message-ID: 200407120914.20052.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Bruce Momjian wrote:
> I have added this patch plus your later comments to the patch queue.

The autovacuum process still uses libpq to send its queries, which is
not the idea behind backend integration.

> 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.
>
> ---------------------------------------------------------------------
>------
>
> Matthew T. O'Connor wrote:
> > I have make the changes suggested after I posted my last patch, I
> > have also make several additional improvements. it needs to be
> > tested more, but since the deadline is coming up so soon, I wanted
> > to post an update just to keep everyone abreast of what I'm doing.
> > Please review and let me know what I need to change to get it
> > applied to CVS.
> >
> > As before, 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.
> >
> > I assume I will have to write the docs for this, but right now I'm
> > focusing on the code, I get get the docs written after the feature
> > freeze.
> >
> > Matthew O'Connor
>
> [ Attachment, skipping... ]
>
> [ Attachment, skipping... ]
>
> > ---------------------------(end of
> > broadcast)--------------------------- TIP 8: explain analyze is
> > your friend

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Andreas Pflug 2004-07-12 07:42:41 Re: pg_autovacuum integration attempt #2
Previous Message Christopher Kings-Lynne 2004-07-12 04:30:31 Re: Updated ALTER TABLE ... SET TABLESPACE patch