Re: LWLocks by LockManager slowing large DB - Mailing list pgsql-performance

From Tom Lane
Subject Re: LWLocks by LockManager slowing large DB
Date
Msg-id 3395561.1618352948@sss.pgh.pa.us
Whole thread Raw
In response to Re: LWLocks by LockManager slowing large DB  (Andres Freund <andres@anarazel.de>)
Responses Re: LWLocks by LockManager slowing large DB
List pgsql-performance
Andres Freund <andres@anarazel.de> writes:
> On 2021-04-13 11:47:06 -0700, Paul Friedman wrote:
>> YES!!!  This completely alleviates the bottleneck and I'm able to run the
>> queries full-throttle.  Thank you SO much for your help+insight.

> Cool. And damn: I can't immediately think of a way to optimize this to
> not require this kind of hack in the future.

Maybe the same thing we do with user tables, ie not give up the lock
when we close a toast rel?  As long as the internal lock counters
are 64-bit, we'd not have to worry about overflowing them.

            regards, tom lane



pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: LWLocks by LockManager slowing large DB
Next
From: Paul Friedman
Date:
Subject: RE: LWLocks by LockManager slowing large DB