Resent-From: decibel@decibel.org
Resent-Date: Mon, 14 May 2007 12:49:46 -0500
Resent-Message-ID: <20070514174946.GT69517@decibel.org>
Resent-To: pgsql-performance@postgresql.org
Date: Mon, 14 May 2007 12:45:58 -0500
From: "Jim C. Nasby" <decibel@decibel.org>
To: Y Sidhu <ysidhu@gmail.com>
Subject: Re: pg_stats how-to?
Message-ID: <20070514174558.GS69517@decibel.org>
References: <4647B0A9.7080304@gmail.com>
	<bf54be870705131751g32e29447l4ec3a2bfabca10e6@mail.gmail.com>
	<b09064f30705140916o7c1d1a24h2bdabd3714df2187@mail.gmail.com>
	<20070514162610.GO69517@nasby.net>
	<b09064f30705140928x6b44f03dtdb93ebd18e7cdaca@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <b09064f30705140928x6b44f03dtdb93ebd18e7cdaca@mail.gmail.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

Please include the list in your replies...

Ok, so you've got stats collection turned on. What's the question then?
And are stats_block_level and stats_row_level also enabled?

On Mon, May 14, 2007 at 09:28:46AM -0700, Y Sidhu wrote:
> yes
> 
> Yudhvir
> ===
> 
> On 5/14/07, Jim C. Nasby <decibel@decibel.org> wrote:
> >
> >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 <shoaibmir@gmail.com> 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)
> >
> 
> 
> 
> -- 
> Yudhvir Singh Sidhu
> 408 375 3134 cell

-- 
Jim C. Nasby, Database Architect                decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"