Re: pg_autovacuum (pg_avd version 2)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_autovacuum (pg_avd version 2)
Date: 2003-03-18 17:23:00
Message-ID: 200303181723.h2IHN0i06116@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


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)

--
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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-03-18 22:11:35 Re: pg_autovacuum (pg_avd version 2)
Previous Message Bruce Momjian 2003-03-18 17:21:19 Re: InvalidOid & C++