Re: 8.1.8 autovacuum missing databases - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: 8.1.8 autovacuum missing databases
Date
Msg-id 20080502195210.GE21477@commandprompt.com
Whole thread Raw
In response to Re: 8.1.8 autovacuum missing databases  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 8.1.8 autovacuum missing databases  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.1.8 autovacuum missing databases
Next
From: Tom Lane
Date:
Subject: Re: 8.1.8 autovacuum missing databases