pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (3+ messages)  latest in thread

Message-ID: <7e4ba9550701240049w22e65273s3dc8ba58a9a735b@mail.gmail.com>
Permalink:  ../7e4ba9550701240049w22e65273s3dc8ba58a9a735b@mail.gmail.com/
Also on:    postgresql.org/message-id/7e4ba9550701240049w22e65273s3dc8ba58a9a735b@mail.gmail.com

 · 

reply

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