Horton

Re: Optimization

Peter Childs <blue.dragon@blueyonder.co.uk>

View thread
From: Peter Childs <blue.dragon@blueyonder.co.uk>
To:
Cc: pgsql-performance@postgresql.org
Date: 2003-07-29T07:14:59Z
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