Date: Fri, 29 Jun 2007 09:33:51 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Richard Huxton <dev@archonet.com>
Cc: Ho Fat Tsang <namiwf@gmail.com>, pgsql-performance@postgresql.org
Subject: Re: PostgreSQL 8.0 occasionally slow down
Message-ID: <20070629133351.GE5184@alvh.no-ip.org>
References: <97e6e20f0706272354m5e42c91em177c8b80abb2ea52@mail.gmail.com>
	<468361A9.1040308@archonet.com>
	<97e6e20f0706280101y543b871ao4cbf85e57f07f7e9@mail.gmail.com>
	<46836B66.7050109@archonet.com>
	<97e6e20f0706280117h20ab2e03n770abc588f17742@mail.gmail.com>
	<46837C50.20603@archonet.com>
	<97e6e20f0706281904v4b7c4a97p570deda85e590ee4@mail.gmail.com>
	<4684CF12.5010003@archonet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <4684CF12.5010003@archonet.com>
User-Agent: Mutt/1.5.13 (2006-08-11)

Richard Huxton escribió:
> Ho Fat Tsang wrote:

> >  Correct me if i am wrong. It seems postgresql 8.0 does not bundle
> >auto-vacuum by default. So all vacuum and analyse are done manually ? So
> >what i have tested related to vaccuum is running auto-vacuum (a executeable
> >located in /bin) parallel under normal production load but it seems won't
> >help.
> 
> Can't remember whether 8.0 had autovacuum bundled and turned off or not 
> bundled at all. If it's not running it can't be causing this problem though.

The separate binary he found is the contrib pg_autovacuum.  Integrated
autovac got into 8.1.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.