Re: PostgreSQL 8.0 occasionally slow down - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: PostgreSQL 8.0 occasionally slow down
Date
Msg-id 20070629133351.GE5184@alvh.no-ip.org
Whole thread Raw
In response to Re: PostgreSQL 8.0 occasionally slow down  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PostgreSQL 8.0 occasionally slow down
Next
From: "Dolafi, Tom"
Date:
Subject: Re: rtree/gist index taking enormous amount of space in 8.2.3