Re: Slow Vacuum was: vacuum output question

On Tue, Dec 30, 2008 at 9:32 AM, Dan Armbrust
<daniel(dot)armbrust(dot)list(at)gmail(dot)com> 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.