Re: Optimization - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: Optimization
Date
Msg-id 3F266DD2.30197.46AAB7A@localhost
Whole thread Raw
In response to Re: Optimization  (Peter Childs <blue.dragon@blueyonder.co.uk>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Peter Childs
Date:
Subject: Re: Optimization
Next
From: "Christopher Browne"
Date:
Subject: autovacuum