| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dolafi, Tom | 2007-06-29 13:51:19 | Re: rtree/gist index taking enormous amount of space in 8.2.3 |
| Previous Message | Richard Huxton | 2007-06-29 09:21:22 | Re: PostgreSQL 8.0 occasionally slow down |