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

From: "shakahshakah(at)gmail(dot)com" <shakahshakah(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
Date: 2007-01-29 20:14:47
Message-ID: 1170101687.591306.48110@l53g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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%.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2007-01-29 20:19:55 Re: Locking question?
Previous Message TWENGER2 2007-01-29 20:06:43 dependency ?