Please tell me what I'm missing?
My stats Postgres 7.4 parameters are as follows:-
stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
stats_reset_on_server_start = true
After turning all of these on, I restarted Postgres, then ran a table query and saw statistics appear in the following view:-
pg_statio_all_tables
However, since that first test query yesterday (and I've run several since on different tables today - some of them repeated to ensure the buffer should be populated), the statistics haven't changed. Is there another parameter, or more space, or something, that I need to allocate please? Even the stats on the system tables don't appear to change with several users on ths system.
Adrian