Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 815FB6324BE for ; Wed, 21 Jan 2009 11:34:50 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00683-07 for ; Wed, 21 Jan 2009 11:34:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from milkno.com (pfeiffer02.nmmn.net [217.114.78.33]) by mail.postgresql.org (Postfix) with ESMTP id F1D48632417 for ; Wed, 21 Jan 2009 11:34:43 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by milkno.com (Postfix) with ESMTP id 973E215CC0AB; Wed, 21 Jan 2009 16:34:34 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at milkno.com Received: from milkno.com ([127.0.0.1]) by localhost (localhost [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id yoqKdnUeIJWb; Wed, 21 Jan 2009 16:34:33 +0100 (CET) Received: from [192.168.97.30] (automatix.transfer.langbehn.hh.nmmn.net [217.114.64.90]) by milkno.com (Postfix) with ESMTPA id B198F15CC09C; Wed, 21 Jan 2009 16:34:33 +0100 (CET) Message-ID: <49774090.5020300@netzmeister-st-pauli.de> Date: Wed, 21 Jan 2009 16:34:40 +0100 From: Andreas Wenk User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: Alvaro Herrera CC: Abdul Rahman , pgsql-admin@postgresql.org Subject: Re: autovacuum daemon References: <167846.41430.qm@web65715.mail.ac4.yahoo.com> <20090121151445.GF4038@alvh.no-ip.org> In-Reply-To: <20090121151445.GF4038@alvh.no-ip.org> X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/93 X-Sequence-Number: 31140 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alvaro Herrera schrieb: > Abdul Rahman wrote: >> Deal All, >> >> I have set postgresql.conf for autovacuum and need to know weather the >> process is running/working or not. > > Run this query: > SHOW autovacuum; way easiere than my approach ;-) Thanks! Andy - -- St.Pauli - Hamburg - Germany Andreas Wenk > > If it says "on", then it is working. > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJd0CPVa7znmSP9AwRAq0bAKDUENJo040IJDoDfEUKHUFMd61jqACg0X02 NljMvjCXVvNObOwFXlpVGbA= =ba05 -----END PGP SIGNATURE-----