Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BD29F9FBAB0 for ; Mon, 14 May 2007 13:26:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14871-10 for ; Mon, 14 May 2007 13:26:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 44A859FBA43 for ; Mon, 14 May 2007 13:26:16 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id EC2B756441; Mon, 14 May 2007 11:26:14 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 14 May 2007 11:26:11 -0500 Date: Mon, 14 May 2007 11:26:10 -0500 From: "Jim C. Nasby" To: Y Sidhu Cc: Shoaib Mir , pgsql-performance@postgresql.org Subject: Re: pg_stats how-to? Message-ID: <20070514162610.GO69517@nasby.net> References: <4647B0A9.7080304@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070514:ysidhu@gmail.com::pb/gCDajMSzRHGXj:02QDJ X-Hashcash: 1:20:070514:shoaibmir@gmail.com::XumYJWj35DYd4iiX:000000000000000000 0000000000000000000000004IGV X-Hashcash: 1:20:070514:pgsql-performance@postgresql.org::K/wPVqS8zYT8k8f4:00000 0000000000000000000000001/Uz X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/251 X-Sequence-Number: 24641 Have you either re-loaded the config or restarted the server since making those changes? On Mon, May 14, 2007 at 09:16:54AM -0700, Y Sidhu wrote: > I am trying to use them. I have set these values in my conf file: > stats_start_collector TRUE stats_reset_on_server_start FALSE > stats_command_string TRUE > now what? > > Yudhvir > ========== > > On 5/13/07, Shoaib Mir wrote: > > > >Can you be a little more specific? What exactly are you trying to achieve > >with pg_stats? > > > >You can always get help for documentation at --> > >http://www.postgresql.org/docs/8.2/static/view-pg-stats.html > > > > > >-- > >Shoaib Mir > >EnterpriseDB (www.enterprisedb.com) > > > >On 5/13/07, Yudhvir Singh Sidhu < ysidhu@gmail.com> wrote: > >> > >> Anyone know of a pg_stats howto? I'd appreciate any direction. > >> > >> Yudhvir > >> > >> ---------------------------(end of broadcast)--------------------------- > >> TIP 1: if posting/reading through Usenet, please send an appropriate > >> subscribe-nomail command to majordomo@postgresql.org so that your > >> message can get through to the mailing list cleanly > >> > > > > > > > -- > Yudhvir Singh Sidhu > 408 375 3134 cell -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)