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 E00869DC82D for ; Mon, 13 Feb 2006 13:46:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74566-08 for ; Mon, 13 Feb 2006 13:46:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id C64E49DC848 for ; Mon, 13 Feb 2006 13:46:31 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 2582D3982E; Mon, 13 Feb 2006 17:46:32 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Mon, 13 Feb 2006 11:46:31 -0600 Date: Mon, 13 Feb 2006 11:46:31 -0600 From: "Jim C. Nasby" To: juliano.gaio@gmail.com Cc: pgsql-admin@postgresql.org Subject: Re: vacuumdb Message-ID: <20060213174631.GB57845@pervasive.com> References: <1e9221d50602130842x1a5d817fi@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1e9221d50602130842x1a5d817fi@mail.gmail.com> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060213:juliano.gaio@gmail.com::L8fkAnRZORYw2bUU:000000000000000 0000000000000000000000001siO X-Hashcash: 1:20:060213:pgsql-admin@postgresql.org::tTGe0SYUg9XwSLaF:00000000000 0000000000000000000000001fNx X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200602/165 X-Sequence-Number: 20586 On Mon, Feb 13, 2006 at 01:42:06PM -0300, Juliano wrote: > Hi all, > > There is a way to see vacuumdb last running ? If you mean you'd like to know when a vacuum was last run on a table, sadly, there is no way. Though if you're using 8.1 and have autovacuum enabled there may be some way to see when it last vacuumed something. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461