Re: pg_autovacuum (pg_avd version 2)

We did, but he contacted me directly asking if it could be put in
/contrib for 7.4 so it would get some testing and usage. Is that valid?

---------------------------------------------------------------------------

Peter Eisentraut wrote:
> Did we not tend in the direction of a server-side solution?
>
> Bruce Momjian writes:
>
> > 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 updated my pg_autovacuum program (formerly pg_avd, the name
> > > changed as per discussion on the patches list).
> > >
> > > This version should be a good bit better. It addresses all the issues
> > > pointed out by Neil Conway. Vacuum and Analyze are now handled
> > > separately. It now monitors for xid wraparound. The number of database
> > > connections and queries has been significantly reduced compared the
> > > previous version. I have moved it from bin to contrib. More detail on
> > > the changes are in the TODO file.
> > >
> > > I have not tested the xid wraparound code as I have to let my AthlonXP
> > > 1600 run select 1 in a tight loop for approx. two days in order to
> > > perform the required 500,000,000 xacts.
> > >
> > > Side note: in trying to test the xid wrap around code I noted that the
> > > select 1 query is nearly 30% slower with stats_row_level = true. I
> > > guess this is another reason for a backend integrated autovacuum that
> > > not built on top of the stats system. I know the net effect is reduced
> > > with more realistic queries but still seems like a lot.
> > >
> > > As always, any and all feedback is appreciated.
> > >
> > > Matthew T. O'Connor
> > >
> > >
> >
> > [ Attachment, skipping... ]
> >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the unregister command
> > > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
> >
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073