Re: Auxiliary Processes and MyAuxProc

From: Mike Palmiotto <mike(dot)palmiotto(at)crunchydata(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Yuli Khodorkovskiy <yuli(dot)khodorkovskiy(at)crunchydata(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Auxiliary Processes and MyAuxProc
Date: 2019-09-30 19:13:18
Message-ID: CAMN686FcMWT6AK6ZfyaS3Jzx4TP5UOYnUraeatqfzUxhihxV7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 26, 2019 at 6:03 PM Mike Palmiotto
<mike(dot)palmiotto(at)crunchydata(dot)com> wrote:
>
> On Thu, Sep 26, 2019 at 10:56 AM Alvaro Herrera
> <alvherre(at)2ndquadrant(dot)com> wrote:
> <snip>
> >
> > Well, I think it would be easier to manage as split patches, yeah.
> > I think it'd be infrastructure that needs to be carefully reviewed,
> > while the other ones are mostly boilerplate. If I were the committer
> > for it, I would push that initial patch first immediately followed by
> > conversion of some process that's heavily exercised in buildfarm, wait
> > until lack of trouble is evident, followed by a trickle of pushes to
> > adapt the other processes.
>
> Thanks for the feedback! I've rebased and tested on my F30 box with
> and without EXEC_BACKEND. Just working on splitting out the patches
> now and will post the new patchset as soon as that's done (hopefully
> sometime tomorrow).

Attached is the reworked and rebased patch set. I put the hook on top
and a separate commit for each process type. Note that avworker and
avlauncher were intentionally left together. Let me know if you think
those should be split out as well.

Tested again with and without EXEC_BACKEND. Note that you'll need to
set randomize_va_space to 0 to disable ASLR in order to avoid
occasional failure in the EXEC_BACKEND case.

Please let me know if anything else jumps out to you.

Thanks,
--
Mike Palmiotto
https://crunchydata.com

Attachment Content-Type Size
0007-Add-backends-to-process-centralization.patch text/x-patch 13.1 KB
0008-Add-a-hook-to-allow-extensions-to-set-worker-metadat.patch text/x-patch 2.1 KB
0006-Add-bgworker-to-process-centralization.patch text/x-patch 25.4 KB
0005-Add-syslogger-to-process-centralization.patch text/x-patch 8.4 KB
0004-Add-archiver-to-process-centralization.patch text/x-patch 5.9 KB
0002-Add-centralized-autovac-launcher-worker.patch text/x-patch 11.4 KB
0003-Add-centralized-stat-collector.patch text/x-patch 6.2 KB
0001-Add-ForkProcType-infrastructure.patch text/x-patch 13.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2019-09-30 19:17:50 Revert back to standard AC_STRUCT_TIMEZONE Autoconf macro
Previous Message Alvaro Herrera 2019-09-30 19:12:38 Re: Commit fest 2019-09