Re: straightening out backend process startup - Mailing list pgsql-hackers

From Tom Lane
Subject Re: straightening out backend process startup
Date
Msg-id 1641854.1627923456@sss.pgh.pa.us
Whole thread Raw
In response to straightening out backend process startup  (Andres Freund <andres@anarazel.de>)
Responses Re: straightening out backend process startup
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> I think there's quite a few different issues around this - here I'm just
> trying to tackle a few of the most glaring (to me):

No opinion yet about most of this, but I did want to react to

> In fact, I think there's a good argument to be made that we should
> entirely remove the concept of BackendIds and just use pgprocnos. We
> have a fair number of places like SignalVirtualTransaction() that need
> to search the procarray just to find the proc to signal based on the
> BackendId. If we used pgprocno instead, that'd not be needed.

If I understand what you're suggesting, it'd result in unused slots
in sinvaladt.c's procState[] array, which could create an annoying
drag on performance.  However, I think it might be reasonable to
switch other things over to using pgprocnos, with an eye to
eventually making BackendIds private to the sinval mechanism.
There's certainly no strong reason why sinval's array indexes
need to be used as identifiers by other modules.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Chris Cleveland
Date:
Subject: Passing data out of indexam or tableam
Next
From: Andres Freund
Date:
Subject: Re: straightening out backend process startup