pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Richard Huxton <dev@archonet.com>
Cc: Ho Fat Tsang <namiwf@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL 8.0 occasionally slow down
Date: Fri, 29 Jun 2007 09:33:51 -0400
Message-ID: <20070629133351.GE5184@alvh.no-ip.org> (raw)
In-Reply-To: <4684CF12.5010003@archonet.com>
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>

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.



view thread (18+ messages)  latest in thread

Message-ID: <20070629133351.GE5184@alvh.no-ip.org>
Permalink:  ../20070629133351.GE5184@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070629133351.GE5184@alvh.no-ip.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: alvherre@commandprompt.com, dev@archonet.com, namiwf@gmail.com
  Subject: Re: PostgreSQL 8.0 occasionally slow down
  In-Reply-To: <20070629133351.GE5184@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox