From abr_ora@yahoo.com Wed Jan  21 14:53:13 2009
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id B67696324C6
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 21 Jan 2009 10:53:13 -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 53579-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 21 Jan 2009 10:53:07 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web65715.mail.ac4.yahoo.com (web65715.mail.ac4.yahoo.com
	[76.13.9.107])
	by mail.postgresql.org (Postfix) with SMTP id 6A95F632480
	for <pgsql-admin@postgresql.org>; Wed, 21 Jan 2009 10:53:07 -0400 (AST)
Received: (qmail 42023 invoked by uid 60001); 21 Jan 2009 07:46:25 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=Wj563ADEQw7aufB8YEpUHa0gBRSe+h+m4qmx5SSTBAbn29RvvCATuE2PPLNTTOt+VV8iA1naMSGNqNWC0OfjXL2vMv+ZQExC0mIqVmsEnu89iOkv8JCfg8MKFMn58tH+EVpc7sOG5bfh2s1ZXifAJA3vox7PC6R3RLEnlwUjM+8=;
X-YMail-OSG: 
 lYN7LiAVM1kYxM5phdBN0BLCoQFEhYDIz1VRyLFog2CdW0QPxJT24dnmk6BjVovzeMSpvkQBJfSeDKbN3jNf3dsQKdDopwdjImxji8Rv5gnxpySVfsarvWLwWCQN7SCYANPwZu4JZ5NE6DMJ9RxNHEBZQm2sD4.5zQ37IEfgFZ0QdIeXAT6iO03OWCh2eQ--
Received: from [125.209.91.158] by web65715.mail.ac4.yahoo.com via HTTP;
	Tue, 20 Jan 2009 23:46:25 PST
X-Mailer: YahooMailRC/1155.45 YahooMailWebService/0.7.260.1
Date: Tue, 20 Jan 2009 23:46:25 -0800 (PST)
From: Abdul Rahman <abr_ora@yahoo.com>
Subject: autovacuum daemon
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-2021580083-1232523985=:41430"
Message-ID: <167846.41430.qm@web65715.mail.ac4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200901/85
X-Sequence-Number: 31132

--0-2021580083-1232523985=:41430
Content-Type: text/plain; charset=us-ascii

Deal All,

I have set postgresql.conf for autovacuum and need to know weather the process is running/working or not.

Regards,
Avdul Rehman.



      
--0-2021580083-1232523985=:41430
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:verdana,helvetica,sans-serif;font-size:10pt"><div>Deal All,<br><br>I have set postgresql.conf for autovacuum and need to know weather the process is running/working or not.<br><br>Regards,<br>Avdul Rehman.<br></div></div><br>

      </body></html>
--0-2021580083-1232523985=:41430--



From alvherre@commandprompt.com Wed Jan  21 15:15:36 2009
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 272BD632564
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 21 Jan 2009 11:15:36 -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 80398-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 21 Jan 2009 11:15:32 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by mail.postgresql.org (Postfix) with ESMTP id 07BA3632591
	for <pgsql-admin@postgresql.org>; Wed, 21 Jan 2009 11:14:54 -0400 (AST)
Received: from perhan.alvh.no-ip.org (200-85-214-61.bk4-dsl.surnet.cl
	[200.85.214.61]) (authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id n0LFKY6u005074
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Wed, 21 Jan 2009 07:20:37 -0800
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id D530E47CD9; Wed, 21 Jan 2009 12:14:45 -0300 (CLST)
Date: Wed, 21 Jan 2009 12:14:45 -0300
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Abdul Rahman <abr_ora@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: autovacuum daemon
Message-ID: <20090121151445.GF4038@alvh.no-ip.org>
References: <167846.41430.qm@web65715.mail.ac4.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <167846.41430.qm@web65715.mail.ac4.yahoo.com>
User-Agent: Mutt/1.5.18 (2008-05-17)
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Wed, 21 Jan 2009 07:20:40 -0800 (PST)
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/90
X-Sequence-Number: 31137

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;

If it says "on", then it is working.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



From a.wenk@netzmeister-st-pauli.de Wed Jan  21 15:34:50 2009
Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 815FB6324BE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <a.wenk@netzmeister-st-pauli.de>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@commandprompt.com>
CC: Abdul Rahman <abr_ora@yahoo.com>, 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-----