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

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster