The stats_block_level and stats_row_level are NOT enabled. The question is how to use pg_stats. Do I access/see them via the ANALYZE command? or using SQL. I cannot find any document which will get me started on this.
Yudhvir -------------- On 5/14/07, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 < [EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that > >your > >> >> message can get through to the mailing list cleanly > >> >> > >> > > >> > > >> > >> > >> -- > >> Yudhvir Singh Sidhu > >> 408 375 3134 cell > > > >-- > >Jim Nasby [EMAIL PROTECTED] > >EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) > > > > > > -- > Yudhvir Singh Sidhu > 408 375 3134 cell -- Jim C. Nasby, Database Architect [EMAIL PROTECTED] 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?"
-- Yudhvir Singh Sidhu 408 375 3134 cell