| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Bhella Paramjeet-PFCW67 <PBhella(at)motorola(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: tuning auto vacuum for highly active tables |
| Date: | 2010-03-24 03:22:57 |
| Message-ID: | 20100324032257.GF3240@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Alvaro Herrera escribió:
> Also, keep in mind that max_workers is a new setting in 8.3. Since the
> OP is running 8.2, he can only get one "worker". Presumable he needs to
> disable autovac for those two very active tables and setup a cron job to
> process them in their own schedule.
Err, sorry, "she", not "he".
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guy Deleeuw | 2010-03-24 16:42:10 | How to use an alias name in the current select |
| Previous Message | Alvaro Herrera | 2010-03-24 03:20:23 | Re: tuning auto vacuum for highly active tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yeb Havinga | 2010-03-24 08:55:55 | Re: mysql to postgresql, performance questions |
| Previous Message | Alvaro Herrera | 2010-03-24 03:20:23 | Re: tuning auto vacuum for highly active tables |