From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Optimization
Date: Tue, 29 Jul 2003 12:21:59 +0530
Message-ID: <3F2666E7.7231.44FA68B@localhost> (raw)
In-Reply-To: <200307281227.44072.josh@agliodbs.com>
References: <000f01c35523$f13dee90$ecd36044@tarzan>
On 28 Jul 2003 at 12:27, Josh Berkus wrote:
> Unless you're running PostgreSQL 7.1 or earlier, you should be VACUUMing every
> 10-15 minutes, not every 2-3 hours. Regular VACUUM does not lock your
> database. You will also want to increase your FSM_relations so that VACUUM
> is more effective/efficient; again, see the articles.
There is an auto-vacuum daemon in contrib and if I understand it correctly, it
is not getting much of a field testing. How about you guys installing it and
trying it?
Bye
Shridhar
--
O'Reilly's Law of the Kitchen: Cleanliness is next to impossible
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: shridhar_daithankar@persistent.co.in
Subject: Re: Optimization
In-Reply-To: <3F2666E7.7231.44FA68B@localhost>
* 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