| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Melih Mutlu <m(dot)melihmutlu(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: wake up logical workers after ALTER SUBSCRIPTION |
| Date: | 2022-12-14 23:17:27 |
| Message-ID: | 20221214231727.GA828014@nathanxps13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-12-14 23:24:18 | Re: Error-safe user functions |
| Previous Message | Thomas Munro | 2022-12-14 22:59:39 | Re: [PATCH] Enable using llvm jitlink as an alternative llvm jit linker of old Rtdyld. |