Re: VACUUM killing my CPU

From: Rudi Starcevic <tech(at)wildcash(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM killing my CPU
Date: 2006-05-10 04:18:15
Message-ID: 44616987.3030900@wildcash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2006-05-10 04:41:20 Re: Arguments Pro/Contra Software Raid
Previous Message Alan Hodgson 2006-05-10 04:08:33 Re: VACUUM killing my CPU