Re: track_planning causing performance regression - Mailing list pgsql-hackers

From Andres Freund
Subject Re: track_planning causing performance regression
Date
Msg-id 20200630190613.lcdrxpzjhuw6chtt@alap3.anarazel.de
Whole thread Raw
In response to Re: track_planning causing performance regression  (Ants Aasma <ants@cybertec.at>)
List pgsql-hackers
Hi,

On 2020-06-30 14:30:03 +0300, Ants Aasma wrote:
> Futex is a Linux kernel call that allows to build a lock that has
> uncontended cases work fully in user space almost exactly like a spinlock,
> while falling back to syscalls that wait for wakeup in case of contention.
> It's not portable, but probably something similar could be implemented for
> other operating systems. I did not pursue this further because it became
> apparent that every performance critical spinlock had already been removed.

Our lwlock implementation does have that property already, though. While
the kernel wait is implemented using semaphores, those are implemented
using futexes internally (posix ones, not sysv ones, so only after
whatever version we switched the default to posix semas on linux).

I'd rather move towards removing spinlocks from postgres than making
their implementation more complicated...

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: track_planning causing performance regression
Next
From: Andres Freund
Date:
Subject: Re: warnings for invalid function casts