From: Pavan Deolasee <pavan.deolasee@gmail.com>
To: Jesper Krogh <jesper@krogh.cc>
Cc: pgsql-admin@postgresql.org
Subject: Re: autovacuum?
Date: Fri, 18 Apr 2008 08:29:55 +0530
Message-ID: <2e78013d0804171959k60d2f95ao5e735023433fbe43@mail.gmail.com> (raw)
In-Reply-To: <4807A9A1.9040806@krogh.cc>
References: <4807A9A1.9040806@krogh.cc>
On Fri, Apr 18, 2008 at 1:18 AM, Jesper Krogh <jesper@krogh.cc> wrote:
>
>
> So it seems to be running.
Yes.
> But shouldn't it hit the table a lot more?
That depends on your autovac settings, especially
autovacuum_vacuum_scale_factor. If it is set to 0.2 (which is
default), then autovacuum would hit the table whenever the percentage
of dead tuples is at least 20%. Again, the percentage of dead tuples
depends on your table size and rate of insert/update/delete.
> How do I check that it is somehow near optimal?
>
Again that depends on how much table bloat you can sustain. If you
don't want the table to bloat too much, you can set aggressive
settings for autovac. But that would trigger autovac more often and
may have performance implication on your other concurrent queries.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com
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-admin@postgresql.org
Cc: pavan.deolasee@gmail.com, jesper@krogh.cc
Subject: Re: autovacuum?
In-Reply-To: <2e78013d0804171959k60d2f95ao5e735023433fbe43@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