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 -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches