|
Home > Archive > PostgreSQL Administration > September 2005 > Stats turned on but not being updated
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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_collecto
r = true
stats_command_string
= true
stats_block_level = true
stats_row_level = true
stats_reset_on_serve
r_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
| |
| Tom Lane 2005-09-09, 3:23 am |
| 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
|
|
|
|
|