Re: pgsql: Publish more openly the fact that autovacuum is working for

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Publish more openly the fact that autovacuum is working for
Date: 2008-07-21 15:45:14
Message-ID: 14244.1216655114@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

alvherre(at)postgresql(dot)org (Alvaro Herrera) writes:
> Publish more openly the fact that autovacuum is working for wraparound
> protection.

Now that I look more closely, there are two things I don't like about
this patch:

* it fails to ratchet up MAX_AUTOVAC_ACTIV_LEN to allow for the
additional text

* it produces something like

autovacuum: VACUUM (to prevent wraparound) foo.bar

I had thought we were generating

autovacuum: VACUUM foo.bar (to prevent wraparound)

which seems both easier to read and less likely to break any
existing code that might be trying to interpret pg_stat_activity
entries.

regards, tom lane

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message User Jbcooley 2008-07-22 05:13:03 npgsql - Npgsql2: Improve function metadata queries
Previous Message Tom Lane 2008-07-21 15:27:14 Re: Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the