Re: 8.1.8 autovacuum missing databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Sullivan <ajs(at)commandprompt(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.1.8 autovacuum missing databases
Date: 2008-05-02 20:18:17
Message-ID: 21487.1209759497@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Andrew Sullivan <ajs(at)commandprompt(dot)com> writes:
> On Fri, May 02, 2008 at 12:45:07PM -0400, Tom Lane wrote:
>> to have exposed last_autovac_time anywhere in the pgstat views.
>> Obviously we cannot back-patch that, but I think it should be fixed
>> going forward.

> That's already fixed in 8.2 and forward (see
> pg_stat_get_last_autovacuum_time() and the pg_stat%tables views).

Uh, no, what that function returns is the per-table
autovac_vacuum_timestamp. A grep through the source code shows that
the per-database last_autovac_time is exposed nowhere.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2008-05-02 20:41:52 Re: 8.1.8 autovacuum missing databases
Previous Message Andrew Sullivan 2008-05-02 19:52:11 Re: 8.1.8 autovacuum missing databases