Re: High SYS CPU - need advise - Mailing list pgsql-general

From Merlin Moncure
Subject Re: High SYS CPU - need advise
Date
Msg-id CAHyXU0yBshNe1OzVEDVNsMS93fsFQzAautirQ-wE_omtB0RH5g@mail.gmail.com
Whole thread Raw
In response to Re: High SYS CPU - need advise  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
On Tue, Nov 20, 2012 at 4:08 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
>> It strikes me as cavalier to be resetting
>> trycounter while sitting under the #1 known contention point for read
>> only workloads.
>
> The only use for the trycounter is to know when to ERROR out with "no
> unpinned buffers available", so not resetting that seems entirely
> wrong.
>
> I would contest "the #1 known contention point" claim.  We know that
> the freelist lock is a point of contention under certain conditions,
> but we (or at least I) also know that it is the mere acquisition of
> this lock, and not the work done while it is held, that is important.

Well, I'm speculating (without evidence) if that is in fact might not
be always true.  It certainly is hard to demonstrate with synthetic
testing though.  I guess the first step would be to whip up a
diagnostic patch to confirm malfeasance in suspicious cases.

merlin


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: High SYS CPU - need advise
Next
From: Jeff Janes
Date:
Subject: Re: High SYS CPU - need advise