Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3AD239FB67D for ; Fri, 30 Mar 2007 11:57:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 72006-03 for ; Fri, 30 Mar 2007 11:56:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.rp-online.de (mail.rp-online.de [149.221.1.199]) by postgresql.org (Postfix) with ESMTP id 039719FB63A for ; Fri, 30 Mar 2007 11:57:03 -0300 (ADT) Received: from idefix.d.rp-online.de (idefix.d.rp-online.de [149.221.100.194]) by mail.rp-online.de (Postfix) with ESMTP id 33D082F9E1; Fri, 30 Mar 2007 16:57:02 +0200 (CEST) From: Thomas Pundt Reply-To: Thomas Pundt Organization: RP Online GmbH To: pgsql-admin@postgresql.org, Carol Walter Subject: Re: autovacuum question Date: Fri, 30 Mar 2007 16:59:41 +0200 User-Agent: KMail/1.9.4 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200703301659.41322.mlists@rp-online.de> X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.10/RELEASE, bases: 30032007 #272721, status: clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.129 tagged_above=0 required=5 tests=AWL=0.130, BAYES_50=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 X-Spam-Level: X-Archive-Number: 200703/233 X-Sequence-Number: 25057 Hi, On Friday 30 March 2007 16:43, Carol Walter wrote: | I ran the command "show autovacuum" and postgres responds with "ON." | My colleague says that I should be able to see it running if I run ps | -aef. He said that he doesn't trust postgres reporting on itself. | When I run the Unix ps command as above I don't see autovacuum. Does | anyone know if it's running or not? This is on a box running Solaris. you will only see it if it is currently processing your databases. Look at the PostgreSQL log file, if it has entries from autovacuum. Ciao, Thomas -- Thomas Pundt ---- http://rp-online.de/ ----