On Thursday 30 October 2008, "Oliver Johnson" <oliverjjohnson(at)gmail(dot)com>
> Another thing to note, we have VACUUM ANALYZE running on an hourly
> interval and the switch from CPU to IO wait appears to always coincide
> with a vacuum.
> What might cause this shift?
The extra disk access caused by vacuum? That seems pretty obvious.
Use auto-vacuum. There's no reason to vacuum your entire database every hour
(doing so reads from disk the entirety of every table and index, and
generates some write activity).
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2008-10-30 22:41:23|
|Subject: Re: CPU utilization vs. IO wait, shared buffers?|
|Previous:||From: Oliver Johnson||Date: 2008-10-30 21:41:40|
|Subject: CPU utilization vs. IO wait, shared buffers?|