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
> 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, Tom||Date: 2007-06-29 13:51:19|
|Subject: Re: rtree/gist index taking enormous amount of space in 8.2.3 |
|Previous:||From: Richard Huxton||Date: 2007-06-29 09:21:22|
|Subject: Re: PostgreSQL 8.0 occasionally slow down|