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

Re: PostgreSQL 8.0 occasionally slow down

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Ho Fat Tsang <namiwf(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.0 occasionally slow down
Date: 2007-06-29 13:33:51
Message-ID: 20070629133351.GE5184@alvh.no-ip.org (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-performance by date

Next:From: Dolafi, TomDate: 2007-06-29 13:51:19
Subject: Re: rtree/gist index taking enormous amount of space in 8.2.3
Previous:From: Richard HuxtonDate: 2007-06-29 09:21:22
Subject: Re: PostgreSQL 8.0 occasionally slow down

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