From: Nathan Bossart <nathandbossart@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: connection establishment versus parallel workers
Date: Mon, 13 Jan 2025 13:50:39 -0600
Message-ID: <Z4Vuj4Q-Otw0JqK0@nathan> (raw)
In-Reply-To: <Z2RFP_4tEEImDfrl@nathan>
References: <Z1n5UpAiGDmFcMmd@nathan>
<CA+hUKGLOcxUa6m7UinPN1gZXFyr92L8btG_pGTHPiWY2YbRw2w@mail.gmail.com>
<CA+hUKGLnaskegyFs8mJu62aa81cPPCkq_Bwf46hge_9Q7=J8TQ@mail.gmail.com>
<Z1tc87_2lsiFwL-l@nathan>
<CA+hUKG+0Su_d71N3vL9K=JpEHm=FzjZYpNntwAdHi+Qsfbimhg@mail.gmail.com>
<Z2RFP_4tEEImDfrl@nathan>
On Thu, Dec 19, 2024 at 10:09:35AM -0600, Nathan Bossart wrote:
> On Fri, Dec 13, 2024 at 03:56:00PM +1300, Thomas Munro wrote:
>> 0001 patch is unchanged, 0002 patch sketches out a response to the
>> observation a couple of paragraphs above.
>
> Both of these patches seem to improve matters quite a bit. I haven't yet
> thought too deeply about it all, but upon a skim, your patches seem
> entirely reasonable to me.
I gave these a closer look, and I still feel that they are both
straightforward and reasonable. IIUC the main open question is whether
this might cause problems for other PM signal kinds. Like you, I don't see
anything immediately obvious there, but I'll admit I'm not terribly
familiar with the precise characteristics of postmaster signals. In any
case, 0001 feels pretty safe to me.
> However, while this makes the test numbers for >= v16 look more like those
> for v15, we're also seeing a big jump from v13 to v14. This bisects pretty
> cleanly to commit d872510. I haven't figured out _why_ this commit is
> impacting this particular test, but I figured I'd at least update the
> thread with what we know so far.
I regrettably have no updates on this one, yet.
--
nathan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: nathandbossart@gmail.com, thomas.munro@gmail.com
Subject: Re: connection establishment versus parallel workers
In-Reply-To: <Z4Vuj4Q-Otw0JqK0@nathan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox