Postgres Pro
Downloads
Home   >   mailing lists

Re: CPU load high - Mailing list pgsql-general

From Hannes Dorbath
Subject Re: CPU load high
Date
Msg-id 46CD4440.4030202@theendofthetunnel.de
Whole thread Raw
In response to Re: CPU load high  ("Max Zorloff" <zorloff@gmail.com>)
Responses Re: CPU load high  ("Max Zorloff" <zorloff@gmail.com>)
List pgsql-general
Tree view 
On 23.08.2007 11:04, Max Zorloff wrote:
> When one postgres process waits for lock to release does it use any cpu?
> And also, when apache waits for query to finish, does it use cpu?

No, but are you sure what you see is not i/o wait? What values does top
display in the %wa columns in the CPU rows? What does iostat -dm 1 say
say under load?


--
Regards,
Hannes Dorbath

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Converting non-null unique idx to pkey
Next
From: Dave Page
Date:
Subject: Re: PostgreSQL vs Firebird feature comparison finished