On Jan 29, 2007, at 3:14 PM, shakahshakah@xxxxxxxxx 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@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)