X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 00FE811F66C6 for ; Mon, 3 Apr 2006 21:04:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17108-08 for ; Mon, 3 Apr 2006 21:04:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 806FE11F66BB for ; Mon, 3 Apr 2006 21:03:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3403wIZ007576; Mon, 3 Apr 2006 20:03:58 -0400 (EDT) To: Jim Nasby cc: "Matthew T. O'Connor" , Gourish Singbal , "pgsql-admin@postgresql.org" Subject: Re: auto vacuuming In-reply-to: <06443D67-9F59-4C98-9A5A-46F80980C611@pervasive.com> References: <674d1f8a0603290206u55f114e1y7bfc2f83696fbada@mail.gmail.com> <20060331174802.GS49405@pervasive.com> <20060331185037.GF14204@surnet.cl> <442DA0CA.1050901@zeut.net> <6991.1143862141@sss.pgh.pa.us> <06443D67-9F59-4C98-9A5A-46F80980C611@pervasive.com> Comments: In-reply-to Jim Nasby message dated "Mon, 03 Apr 2006 11:09:51 -0500" Date: Mon, 03 Apr 2006 20:03:57 -0400 Message-ID: <7575.1144109037@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.114 required=5 tests=[AWL=0.114] X-Spam-Score: 0.114 X-Spam-Level: X-Archive-Number: 200604/39 X-Sequence-Number: 21208 Jim Nasby writes: > The problem with that is unless I missed a change in 8.1, autovac > knows absolutely nothing about when manual vacuums have been run. It knows perfectly well about full-database vacuums (because those set pg_database.datvacuumxid), and by the end of the week or so it'll know about single-table vacuums too: http://archives.postgresql.org/pgsql-patches/2006-04/msg00009.php regards, tom lane