On Tue, Dec 30, 2008 at 9:32 AM, Dan Armbrust <daniel.armbrust.list@xxxxxxxxx> wrote: > Haven't looked at that yet on this particular system. Last time, on > different hardware when this occurred the vmstat 'wa' column showed > very large values while vacuum was running. I don't recall what the > bi/bo columns indicated. definitely sounds like poor io > top also showed very high load averages while vacuum was running - but > basically no cpu use. yeah, load is the number of things running or waiting to run. If vacuum is sucking up all the io, and this machine doesn't have much io capability, then it's quite possible for other processes stuck behind it to crank up the load factor. Also, were the any vacuum cost delay settings over 0 on this machine when the test was run? > Are there any common tools that could do a better disk benchmark than > hdparm -Tt? Keep in mind, hdparm hits the drive directly, not through the filesystem. I use bonnie++ or iozone to test io. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
