pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Statistics not working?? 2+ messages / 2 participants [nested] [flat]
* Statistics not working?? @ 2005-03-11 11:53 Hugo Ferreira <bytter@gmail.com> 2005-03-11 12:03 ` Re: Statistics not working?? Oleg Bartunov <oleg@sai.msu.su> 0 siblings, 1 reply; 2+ messages in thread From: Hugo Ferreira @ 2005-03-11 11:53 UTC (permalink / raw) To: pgsql-performance Hi there! I think I may have a problem with the statistics in my postgresql 8.0 running under Windowx XP. When I view both pg_stat_all_tables and pg_stat_all_indexes, all the numeric columns that should hold the statistics are 0 (zero). My configuration file has the following: stats_start_collector = true stats_command_string = true stats_reset_on_server_start = false Any tip? Thanks in advance, Hugo Ferreira -- GPG Fingerprint: B0D7 1249 447D F5BB 22C5 5B9B 078C 2615 504B 7B85 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Statistics not working?? 2005-03-11 11:53 Statistics not working?? Hugo Ferreira <bytter@gmail.com> @ 2005-03-11 12:03 ` Oleg Bartunov <oleg@sai.msu.su> 0 siblings, 0 replies; 2+ messages in thread From: Oleg Bartunov @ 2005-03-11 12:03 UTC (permalink / raw) To: Hugo Ferreira <bytter@gmail.com>; +Cc: pgsql-performance On Fri, 11 Mar 2005, Hugo Ferreira wrote: > Hi there! > > I think I may have a problem with the statistics in my postgresql 8.0 > running under Windowx XP. When I view both pg_stat_all_tables and > pg_stat_all_indexes, all the numeric columns that should hold the > statistics are 0 (zero). My configuration file has the following: > > stats_start_collector = true > stats_command_string = true > stats_reset_on_server_start = false > > Any tip? You need to define stats_block_level and/or stats_row_level > > Thanks in advance, > > Hugo Ferreira > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-11 12:03 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-03-11 11:53 Statistics not working?? Hugo Ferreira <bytter@gmail.com> 2005-03-11 12:03 ` Oleg Bartunov <oleg@sai.msu.su>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox