Postgres Pro
Downloads
Home   >   mailing lists

Re: A micro-optimisation for ProcSendSignal() - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: A micro-optimisation for ProcSendSignal()
Date
Msg-id CA+hUKGKppRrnvSsbxfzAU7beXO7jVFm-7Rij1_UgPm9cS3FEXQ@mail.gmail.com
Whole thread Raw
Responses Re: A micro-optimisation for ProcSendSignal()
List pgsql-hackers
Tree view 
On Fri, Mar 12, 2021 at 12:31 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> ProcSendSignal(pid) searches the ProcArray for the given pid and then
> sets that backend's procLatch.  It has only two users: UnpinBuffer()
> and ReleasePredicateLocks().  In both cases, we could just as easily
> have recorded the pgprocno instead, avoiding the locking and the
> searching.  We'd also be able to drop some special book-keeping for
> the startup process, whose pid can't be found via the ProcArray.

Rebased.
Attachment

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: What to call an executor node which lazily caches tuples in a hash table? (GUC)
Next
From: Justin Pryzby
Date:
Subject: Re: PoC/WIP: Extended statistics on expressions (\d in old client)