Re: VACUUM killing my CPU - Mailing list pgsql-performance

From Rudi Starcevic
Subject Re: VACUUM killing my CPU
Date
Msg-id 44616987.3030900@wildcash.com
Whole thread Raw
In response to Re: VACUUM killing my CPU  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-performance
Hi,

>>What I am worry about is "93.5% wa" ...
>>
>>Could someone explain me what is the VACUUM process waiting for ?
>>
>
>
> Disk I/O.
>

CPU
wa: Time spent waiting for IO. Prior to Linux 2.5.41, shown as zero.

Just a little more info to help understand what Alan has pointed out.

Your CPU processes are waiting on the HDD ...

HTH

--
Regards,
Rudi


pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: [GENERAL] Arguments Pro/Contra Software Raid
Next
From: Thomas Vatter
Date:
Subject: in memory views