Thread: VACUUM killing my CPU

VACUUM killing my CPU

From
blender@jaskom.pl
Date:
Hi all !

I am running PostgreSQL 7.3.2 on Linux 2.6.13...

What I see when VACUUM process is running is:

Cpu(s):  0.0% us,  3.2% sy,  0.0% ni,  0.0% id, 93.5% wa,  3.2% hi,
0.0% si

What I am worry about is "93.5% wa" ...

Could someone explain me what is the VACUUM process waiting for ?

Best regards
David


Re: VACUUM killing my CPU

From
Alan Hodgson
Date:
On May 9, 2006 02:45 am, blender@jaskom.pl wrote:
> What I am worry about is "93.5% wa" ...
>
> Could someone explain me what is the VACUUM process waiting for ?
>

Disk I/O.

--
In a truly free society, "Alcohol, Tobacco and Firearms" would be a
convenience store chain.


Re: VACUUM killing my CPU

From
Rudi Starcevic
Date:
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