Re: 8.1.8 autovacuum missing databases

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.1.8 autovacuum missing databases
Date: 2008-05-02 19:52:11
Message-ID: 20080502195210.GE21477@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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).
This feature is actually something I think makes upgrading from 8.1 to
8.2 worth the effort.

A

--
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-05-02 20:18:17 Re: 8.1.8 autovacuum missing databases
Previous Message Tom Lane 2008-05-02 16:45:07 Re: 8.1.8 autovacuum missing databases