Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3B3CA633197 for ; Wed, 31 Mar 2010 06:26:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07150-04 for ; Wed, 31 Mar 2010 09:26:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id C108E63358B for ; Wed, 31 Mar 2010 06:26:24 -0300 (ADT) Received: from [192.168.0.7] (uni14-1-82-233-223-216.fbx.proxad.net [82.233.223.216]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 53ED63B8F5; Wed, 31 Mar 2010 11:26:23 +0200 (CEST) Message-ID: <4BB3153F.6010901@lelarge.info> Date: Wed, 31 Mar 2010 11:26:23 +0200 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr; rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3 MIME-Version: 1.0 To: gnanam@zoniac.com CC: pgsql-admin@postgresql.org Subject: Re: Statistics Collector not collecting server activities References: <007501cad09d$326fefc0$974fcf40$@com> <4BB2FA68.6060708@lelarge.info> <00b601cad0b0$5e713760$1b53a620$@com> <4BB31032.6060809@lelarge.info> <00c001cad0b2$a4a89c30$edf9d490$@com> In-Reply-To: <00c001cad0b2$a4a89c30$edf9d490$@com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/278 X-Sequence-Number: 34077 Le 31/03/2010 11:14, Gnanakumar a écrit : > OK. I'll try that way. > > But, as per 8.2 doc, by default it is ON. So if I comment with just '#' > infront of the parameter, and restart PostgreSQL, this change will not be > reflected, which means it should work with default value ON? Yes, you're right. Maybe you have stats_start_collector at different places in your postgresql.conf. The last value is used in this case. So you should better check this. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com