Обсуждение: Stats turned on but not being updated

Поиск
Список
Период
Сортировка

Stats turned on but not being updated

От
adey
Дата:
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

Re: Stats turned on but not being updated

От
Tom Lane
Дата:
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