Thread: Stats turned on but not being updated
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
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
adey <adey11@gmail.com> writes:
> However, since that first test query yesterday (and I've run several since=
> =20
> on different tables today - some of them repeated to ensure the buffer=20
> should be populated), the statistics haven't changed.
That seems pretty odd. Look in the postmaster log to see if you can
find any relevant error messages.
regards, tom lane