Re: Optimization - Mailing list pgsql-performance

From Peter Childs
Subject Re: Optimization
Date
Msg-id Pine.LNX.4.44.0307290812420.511-100000@RedDragon.Childs
Whole thread Raw
In response to Re: Optimization  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Optimization
List pgsql-performance
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?

Peter Childs


pgsql-performance by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Optimization
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Optimization