Re: heavily contended lwlocks with long wait queues scale badly - Mailing list pgsql-hackers

From Robert Haas
Subject Re: heavily contended lwlocks with long wait queues scale badly
Date
Msg-id CA+TgmoZfFxKt4Z6NKBoeV7PDgzCotrkpcSABav5c2iMyXFkeUA@mail.gmail.com
Whole thread Raw
In response to heavily contended lwlocks with long wait queues scale badly  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Thu, Oct 27, 2022 at 12:59 PM Andres Freund <andres@anarazel.de> wrote:
> After pulling my
> hair out for quite a while to try to understand that behaviour, I figured out
> that it's just a side-effect of *removing* some other contention.

I've seen this kind of pattern on multiple occasions. I don't know if
they were all caused by this, or what, but I certainly like the idea
of making it better.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: heapgettup refactoring
Next
From: Tomas Vondra
Date:
Subject: Re: WIP: Aggregation push-down - take2