Re: Puzzling full database lock - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Puzzling full database lock
Date
Msg-id 4014464.S0FXZX0TjZ@skynet.simkin.ca
Whole thread Raw
In response to Re: Puzzling full database lock  (Christopher Opena <counterveil@gmail.com>)
Responses Re: Puzzling full database lock  (Christopher Opena <counterveil@gmail.com>)
List pgsql-general
On Wednesday, February 01, 2012 05:13:15 PM Christopher Opena wrote:
> Do you mean 6-12% of total iowait, or per cpu?  Our average iowait in the
> last week is 34.31% of a total 1600% with an average idle of 1451.76%.  Our
> iowait *does* spike occasionally (today it went up to 148.01%) but it
> doesn't coincide with the lock happening.  At the time of the lock we were
> at 10.58% iowait, which is quite a bit below our average.
>

Total, but it doesn't sound like that's the problem.


pgsql-general by date:

Previous
From: Christopher Opena
Date:
Subject: Re: Puzzling full database lock
Next
From: Christopher Opena
Date:
Subject: Re: Puzzling full database lock