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 06:51:59
Message-ID: 3F2666E7.7231.44FA68B@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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?


O'Reilly's Law of the Kitchen:	Cleanliness is next to impossible

In response to


pgsql-performance by date

Next:From: Peter ChildsDate: 2003-07-29 07:14:59
Subject: Re: Optimization
Previous:From: Rajesh Kumar MallahDate: 2003-07-29 05:44:29
Subject: Why performance improvement on converting subselect to a function ?

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