pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM killing my CPU
3+ messages / 3 participants
[nested] [flat]
* VACUUM killing my CPU
@ 2006-05-09 09:45 blender@jaskom.pl
2006-05-10 04:08 ` Re: VACUUM killing my CPU Alan Hodgson <ahodgson@simkin.ca>
0 siblings, 1 reply; 3+ messages in thread
From: blender@jaskom.pl @ 2006-05-09 09:45 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: VACUUM killing my CPU
2006-05-09 09:45 VACUUM killing my CPU blender@jaskom.pl
@ 2006-05-10 04:08 ` Alan Hodgson <ahodgson@simkin.ca>
2006-05-10 04:18 ` Re: VACUUM killing my CPU Rudi Starcevic <tech@wildcash.com>
0 siblings, 1 reply; 3+ messages in thread
From: Alan Hodgson @ 2006-05-10 04:08 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: VACUUM killing my CPU
2006-05-09 09:45 VACUUM killing my CPU blender@jaskom.pl
2006-05-10 04:08 ` Re: VACUUM killing my CPU Alan Hodgson <ahodgson@simkin.ca>
@ 2006-05-10 04:18 ` Rudi Starcevic <tech@wildcash.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rudi Starcevic @ 2006-05-10 04:18 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-05-10 04:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-09 09:45 VACUUM killing my CPU blender@jaskom.pl
2006-05-10 04:08 ` Alan Hodgson <ahodgson@simkin.ca>
2006-05-10 04:18 ` Rudi Starcevic <tech@wildcash.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox