From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Optimization
Date: Tue, 29 Jul 2003 12:51:30 +0530
Message-ID: <3F266DD2.30197.46AAB7A@localhost> (raw)
In-Reply-To: <Pine.LNX.4.44.0307290812420.511-100000@RedDragon.Childs>
References: <3F2666E7.7231.44FA68B@localhost>
On 29 Jul 2003 at 8:14, Peter Childs wrote:
> On Tue, 29 Jul 2003, Shridhar Daithankar wrote:
>
> > 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?
>
> If there is such a daemon, what is it called? As I can't see it.
> Is it part of gborg?
It is in sources. See contrib module in postgresql CVS, 7.4 beta if you prefer
to wait till announement.
It is called as pgavd..
Bye
Shridhar
--
squatcho, n.: The button at the top of a baseball cap. -- "Sniglets", Rich
Hall & Friends
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: <3F266DD2.30197.46AAB7A@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