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

From: Jim Nasby <decibel(at)decibel(dot)org>
To: shakahshakah(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
Date: 2007-02-02 03:31:26
Message-ID: A2F862AD-604C-478E-B8EC-9AF067E2FB7E@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message RPK 2007-02-02 03:31:39 PostgreSQL/FireBird
Previous Message Jim Nasby 2007-02-02 03:29:21 Re: Predicted lifespan of different PostgreSQL branches