OK. I'll try that way. But, as per 8.2 doc, by default it is ON. So if I comment with just '#' infront of the parameter, and restart PostgreSQL, this change will not be reflected, which means it should work with default value ON? -----Original Message----- From: Guillaume Lelarge [mailto:guillaume@xxxxxxxxxxxx] Sent: Wednesday, March 31, 2010 2:35 PM To: gnanam@xxxxxxxxxx Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Statistics Collector not collecting server activities Le 31/03/2010 10:58, Gnanakumar a écrit : > I?m also seeing a weird thing. If I do ?show stats_start_collector;? inside > psql, it says ?off?. > > I?ve also restarted my server many times after making all the changes. > > As per 8.2 doc, > http://www.postgresql.org/docs/8.2/interactive/runtime-config-statistics.htm > l, stats_start_collector is on by default. > If it is off (as you found with the "show stats_start_collector" statement), you should getting ride of the # in front of the stats_start_collector parameter. Ie, you should have stats_start_collector = on and not #stats_start_collector = on or #stats_start_collector = off Once you've done this, restart PostgreSQL and it should work. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
