Postgres Pro
Downloads
Home   >   mailing lists

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

From shakahshakah@gmail.com
Subject Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
Date
Msg-id 1170101687.591306.48110@l53g2000cwa.googlegroups.com
Whole thread Raw
In response to VACUUM ANALYZE taking a long time, %I/O and %CPU very low  ("shakahshakah@gmail.com" <shakahshakah@gmail.com>)
Responses Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
List pgsql-general
Tree view 
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%.

pgsql-general by date:

Previous
From: Ing. Martin Prášek
Date:
Subject: MULE_INTERNAL translation to win1250
Next
From: "Nik"
Date:
Subject: Re: Record not returned until index is rebuilt