Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low - Mailing list pgsql-general

From Jim Nasby
Subject Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
Date
Msg-id A2F862AD-604C-478E-B8EC-9AF067E2FB7E@decibel.org
Whole thread Raw
In response to Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low  ("shakahshakah@gmail.com" <shakahshakah@gmail.com>)
List pgsql-general
Tree view 
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)

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: relationship in a table
Next
From: Jim Nasby
Date:
Subject: Re: Defining and Using variables in a postgres function