From: Gauri Kanekar <meetgaurikanekar@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Auto Vacuum Problem
Date: Wed, 24 Jan 2007 14:19:06 +0530
Message-ID: <7e4ba9550701240049w22e65273s3dc8ba58a9a735b@mail.gmail.com> (raw)
Hi List,
When auto vacuum is over the dead tuple are seems to get reduced, but
physical size of database do not decreases.
We are using Postgres 8.1.3 and this are the auto vacuum settings.
autovacuum = on # enable autovacuum subprocess?
autovacuum_naptime = 900 # time between autovacuum runs, in
secs
autovacuum_vacuum_scale_factor = 0.1 # fraction of rel size before
autovacuum_analyze_scale_factor = 0.05 # fraction of rel size before
autovacuum_vacuum_cost_delay = 100 # default vacuum cost delay for
How do I make the physical size of the DB smaller without doing a full
vacuum.
Can anybody help me out in this.
--
Regards
Gauri
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: meetgaurikanekar@gmail.com
Subject: Re: Auto Vacuum Problem
In-Reply-To: <7e4ba9550701240049w22e65273s3dc8ba58a9a735b@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