| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance on 8CPU's and 32GB of RAM |
| Date: | 2007-09-05 16:03:48 |
| Message-ID: | 20070905160347.GG6102@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Carlo Stonebanks wrote:
> >> It sounds like you will need a huge lot of vacuuming effort to keep up.
> Maybe you should lower autovac scale factors so that your tables are
> visited more frequently. A vacuum_delay of 40 sounds like too much
> though.
> <<
>
> Does autovacuum not impede performance while it is vacuuming a table?
It causes I/O. Not sure what else you have in mind. vacuum_delay
throttles the I/O usage, at the expense of longer vacuum times.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2007-09-05 16:06:07 | Re: Performance on 8CPU's and 32GB of RAM |
| Previous Message | Carlo Stonebanks | 2007-09-05 15:57:19 | Re: Performance on 8CPU's and 32GB of RAM |