From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | List pgsql-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: Is autovacuum doing a wraparound-avoiding VACUUM? |
Date: | 2008-07-17 21:10:44 |
Message-ID: | 20080717211044.GR3934@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Simon Riggs wrote:
>
> Is autovacuum doing a wraparound-avoiding VACUUM?
> Currently, no easy way to tell.
>
> Patch to change message of autovac in pg_stat_activity when we are
> performing an anti-wraparound VACUUM.
I just obsoleted this patch. The new patch should be easier to do
though -- just a one line change I think.
I don't like your wording though; it feels too verbose (and you're
losing the ANALYZE in case it's doing both things). How about
snprintf(activity, MAX_AUTOVAC_ACTIV_LEN,
"autovacuum: VACUUM%s%s", vac
tab->at_doanalyze ? " ANALYZE" : "",
tab->at_wraparound ? " (wraparound)" : "");
You're not proposing it for 8.3 right?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-07-17 23:02:09 | Re: Is autovacuum doing a wraparound-avoiding VACUUM? |
Previous Message | David Fetter | 2008-07-17 16:01:15 | Re: [PATCHES] WITH RECUSIVE patches 0717 |