On Thursday 30 October 2008, "Oliver Johnson" <oliverjjohnson@xxxxxxxxx> wrote: > 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). -- Alan -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
