Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 594E02E0045 for ; Fri, 2 May 2008 17:18:23 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 03063-04 for ; Fri, 2 May 2008 17:18:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 1826E2E003E for ; Fri, 2 May 2008 17:18:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m42KIIW9021488; Fri, 2 May 2008 16:18:18 -0400 (EDT) To: Andrew Sullivan cc: pgsql-admin@postgresql.org Subject: Re: 8.1.8 autovacuum missing databases In-reply-to: <20080502195210.GE21477@commandprompt.com> References: <22093.1209588237@sss.pgh.pa.us> <1209646882.16174.15.camel@vega.intellivid.com> <7698.1209650248@sss.pgh.pa.us> <1209664799.16174.51.camel@vega.intellivid.com> <17328.1209667453@sss.pgh.pa.us> <1209668403.16174.60.camel@vega.intellivid.com> <17606.1209669106@sss.pgh.pa.us> <20080502161709.GH2320@alvh.no-ip.org> <7391.1209746458@sss.pgh.pa.us> <7451.1209746707@sss.pgh.pa.us> <20080502195210.GE21477@commandprompt.com> Comments: In-reply-to Andrew Sullivan message dated "Fri, 02 May 2008 15:52:11 -0400" Date: Fri, 02 May 2008 16:18:17 -0400 Message-ID: <21487.1209759497@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/25 X-Sequence-Number: 29109 Andrew Sullivan 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