From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: pg_autovacuum (pg_avd version 2) |
Date: | 2003-03-18 22:11:35 |
Message-ID: | Pine.LNX.4.44.0303182311160.3331-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-03-18 22:19:00 | Re: pg_autovacuum (pg_avd version 2) |
Previous Message | Bruce Momjian | 2003-03-18 17:23:00 | Re: pg_autovacuum (pg_avd version 2) |