Re: pg_stats how-to?
От | Jim C. Nasby |
---|---|
Тема | Re: pg_stats how-to? |
Дата | |
Msg-id | 20070514174558.GS69517@decibel.org обсуждение исходный текст |
Ответ на | pg_stats how-to? (Yudhvir Singh Sidhu <ysidhu@gmail.com>) |
Ответы |
Re: pg_stats how-to?
|
Список | pgsql-performance |
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?"
В списке pgsql-performance по дате отправления: