Re: LWLocks by LockManager slowing large DB

From: Andres Freund <andres(at)anarazel(dot)de>
To: Paul Friedman <paul(dot)friedman(at)streetlightdata(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: LWLocks by LockManager slowing large DB
Date: 2021-04-12 22:22:21
Message-ID: 20210412222221.skxrm6mqvniavq2o@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On 2021-04-12 15:15:05 -0700, Paul Friedman wrote:
> Thanks again for any advice you have.

I think we'd need the perf profiles to be able to dig into this
further.

It's odd that there are a meaningful amount of LockManager contention in
your case - assuming the stats you collected weren't just the first few
milliseconds of starting those 60 queries, there shouldn't be any
additional "heavyweight locks" taken given the duration of your queries.

The futex profile hopefully will tell us from where that is coming
from...

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Paul Friedman 2021-04-12 22:56:08 RE: LWLocks by LockManager slowing large DB
Previous Message Paul Friedman 2021-04-12 22:15:05 RE: LWLocks by LockManager slowing large DB