Re: LWLocks by LockManager slowing large DB

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Paul Friedman <paul(dot)friedman(at)streetlightdata(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: LWLocks by LockManager slowing large DB
Date: 2021-04-13 20:54:59
Message-ID: 20210413205459.GA7015@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 2021-Apr-13, Andres Freund wrote:

> > Sounds like I should file this as a requested improvement?
>
> The ability to lock a toast table? Yea, it might be worth doing that. I
> seem to recall this being discussed not too long ago...

Yep, commit 59ab4ac32460 reverted by eeda7f633809. There were some
issues with the semantics of locking views. It didn't seem
insurmountable, but I didn't get around to it.

--
Álvaro Herrera 39°49'30"S 73°17'W
"Use it up, wear it out, make it do, or do without"

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2021-04-13 22:29:08 Re: LWLocks by LockManager slowing large DB
Previous Message Andres Freund 2021-04-13 20:48:06 Re: LWLocks by LockManager slowing large DB