Re: Slow Vacuum was: vacuum output question - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Slow Vacuum was: vacuum output question
Date
Msg-id dcc563d10812300847y188427ffh374a96b853ab417d@mail.gmail.com
Whole thread Raw
In response to Re: Slow Vacuum was: vacuum output question  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
Responses Re: Slow Vacuum was: vacuum output question  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
On Tue, Dec 30, 2008 at 9:32 AM, Dan Armbrust
<daniel.armbrust.list@gmail.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.

pgsql-general by date:

Previous
From: "Dan Armbrust"
Date:
Subject: Re: Slow Vacuum was: vacuum output question
Next
From: "Scott Marlowe"
Date:
Subject: Re: Slow Vacuum was: vacuum output question