From: Robin Iddon <robin@edesix.com>
To: pgsql-admin@postgresql.org
Subject: 8.0.3 pg_autovacuum doesn't clear out stats table?
Date: Thu, 23 Feb 2006 08:32:18 +0000
Message-ID: <43FD7312.5080701@edesix.com> (raw)
Hi,
I wonder if anyone can help me to identify why my background
pg_autovacuum doesn't appear to clear out the stats table entries?
Here is the non-commented lines in my postgresql.conf:
max_connections = 100
shared_buffers = 1000 # min 16, at least max_connections*2,
8KB each
vacuum_cost_delay = 10 # 0-1000 milliseconds
stats_start_collector = true
stats_row_level = true
lc_messages = 'C' # locale for system error message strings
lc_monetary = 'C' # locale for monetary formatting
lc_numeric = 'C' # locale for number formatting
lc_time = 'C' # locale for time formatting
And here is how I start pg_autovacuum:
# The PostgreSQL user is:
PGUSER=postgres
# LOG file is:
PG_AUTOVACUUM_LOG=/var/lib/postgresql/data/pg_autovacuum.log
# See the pg_autovacuum documentation for the details of how these
# parameters affect pg_autovacuum's aggressiveness.
VACUUM_BASE=1000
VACUUM_SCALE=2
SLEEP_BASE=300
SLEEP_SCALE=2
start-stop-daemon -o --chuid $PGUSER --start --quiet --exec
/usr/bin/pg_autovacuum -- -D -v $VACUUM_BASE -V $VACUUM_SCALE -s
$SLEEP_BASE -S $SLEEP_SCALE -L $PG_AUTOVACUUM_LOG
The problem I have is that pg_autovacuum doesn't appear to release the
unused space in the stats tables and so they grow without bounds. It
isn't clear to me that this is costing me anything other than disk
space, but when I run a vacuum full on the database it releases 2.5G of
space accumulated over about 9 months.
Most of my tables are update/append only (i.e. there are very few
deletions from the database), and the space does appear to belong to the
stats tables.
Is this a permissions or configuration issue, or does pg_autovacuum not
consider vacuuming of the stats tables?
Thanks in advance for any help you can offer me ...
Robin
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: robin@edesix.com
Subject: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
In-Reply-To: <43FD7312.5080701@edesix.com>
References: <43FD7312.5080701@edesix.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