Re: Puzzling full database lock

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: Christopher Opena <counterveil(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Puzzling full database lock
Date: 2012-02-02 04:42:37
Message-ID: 4014464.S0FXZX0TjZ@skynet.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Opena 2012-02-02 05:56:16 Re: Puzzling full database lock
Previous Message Christopher Opena 2012-02-02 01:13:15 Re: Puzzling full database lock