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 23:03:54
Message-ID: 20210412230354.5dnx25qqskvh3etd@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On 2021-04-12 15:56:08 -0700, Paul Friedman wrote:
> Also, I didn't understand your comment about a 'futex profile', could you
> point me in the right direction here?

My earlier mail included a section about running a perf profile showing
the callers of the futex() system call, which in turn is what lwlocks
end up using on linux when the lock is contended.

Check the second half of:
https://www.postgresql.org/message-id/20210412215738.xytq33wlciljyva5%40alap3.anarazel.de

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nikolay Samokhvalov 2021-04-12 23:33:45 Re: LWLocks by LockManager slowing large DB
Previous Message Paul Friedman 2021-04-12 22:56:08 RE: LWLocks by LockManager slowing large DB