VACUUM killing my CPU
This is a discussion on VACUUM killing my CPU within the Pgsql Performance forums, part of the PostgreSQL category; --> Hi all ! I am running PostgreSQL 7.3.2 on Linux 2.6.13... What I see when VACUUM process is running ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:45 AM
| ||||
| ||||
 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      |
|
04-19-2008, 08:46 AM
| |||
| |||
| Re: VACUUM killing my CPU 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-19-2008, 08:46 AM
| ||||
| ||||
| Re: VACUUM killing my CPU 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
