From: adey <adey11@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Stats turned on but not being updated
Date: Fri, 9 Sep 2005 13:13:32 +1200
Message-ID: <1c66bda805090818131b095a3@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: adey11@gmail.com
Subject: Re: Stats turned on but not being updated
In-Reply-To: <1c66bda805090818131b095a3@mail.gmail.com>
References: <1c66bda805090818131b095a3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox