Re: Optimization

From: Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimization
Date: 2003-07-29 07:14:59
Message-ID: Pine.LNX.4.44.0307290812420.511-100000@RedDragon.Childs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2003-07-29 07:21:30 Re: Optimization
Previous Message Shridhar Daithankar 2003-07-29 06:51:59 Re: Optimization