Re: [GENERAL] stat collector is not using

2010-02-03 Thread Tom Lane
AI Rumman writes: > I am using Postgresql 8.1. > I set stats_start_collector = on > But I found statistics collector is not using; The collector won't actually collect anything unless you enable at least one of these settings: #stats_command_string = off #stats_block_level = off #stats_row_leve

[GENERAL] stat collector is not using

2010-02-02 Thread AI Rumman
I am using Postgresql 8.1. I set stats_start_collector = on But I found statistics collector is not using; show stats_start_collector; stats_start_collector --- on (1 row) select * from pg_stat_user_indexes where idx_scan > 0; relid | indexrelid | schemaname | relname | i