Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low

On Jan 29, 2007, at 3:14 PM, shakahshakah@gmail.com wrote:
> Never mind.
>
> I found "vacuum_cost_delay" in the docs, I had it set to 70. I set it
> to 0 and watched CPU and I/O% peg to 100%.

FWIW, my experience is that if you're going to use that, a number
between 10 and 20 is usually best.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)