Thread: VACUUM killing my CPU
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
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.
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