public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nathan Bossart <[email protected]>
To: Tom Lane <[email protected]>
Cc: Melih Mutlu <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Hayato Kuroda (Fujitsu) <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: wake up logical workers after ALTER SUBSCRIPTION
Date: Wed, 14 Dec 2022 15:17:27 -0800
Message-ID: <20221214231727.GA828014@nathanxps13> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<20221214000145.GA638663@nathanxps13>
<[email protected]>
<20221214004105.GA669835@nathanxps13>
<20221214171023.GA689106@nathanxps13>
<[email protected]>
<20221214174535.GA773264@nathanxps13>
<[email protected]>
<20221214183759.GC773264@nathanxps13>
<[email protected]>
On Wed, Dec 14, 2022 at 02:02:58PM -0500, Tom Lane wrote:
> Maybe we could have workers that are exiting for that reason set a
> flag saying "please restart me without delay"?
That helps a bit, but there are still delays when starting workers for new
subscriptions. I think we'd need to create a new array in shared memory
for subscription OIDs that need their workers started immediately.
I'm not totally sure this is worth the effort. These delays surface in the
tests because the workers are started so frequently. In normal operation,
this is probably unusual, so the launcher would typically start new workers
immediately. But if you and/or others feel this is worthwhile, I don't
mind working on the patch.
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
view thread (46+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: wake up logical workers after ALTER SUBSCRIPTION
In-Reply-To: <20221214231727.GA828014@nathanxps13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox