Skip site navigation (1) Skip section navigation (2)

Re: Optimization

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimization
Date: 2003-07-29 07:21:30
Message-ID: 3F266DD2.30197.46AAB7A@localhost (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-performance by date

Next:From: Christopher BrowneDate: 2003-07-29 11:56:56
Subject: autovacuum
Previous:From: Peter ChildsDate: 2003-07-29 07:14:59
Subject: Re: Optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group