Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mMAM6-0005ex-4l for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 14:39:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mMAM5-0003EA-59 for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 14:39:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mMAM4-0003E1-Tv for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 14:39:44 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mMAM2-0001sI-SN for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 14:39:44 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 183EdXSE2498876; Fri, 3 Sep 2021 10:39:34 -0400 From: Tom Lane To: "=?UTF-8?B?6JSh5qKm5aifKOeOiuS6jik=?=" cc: "pgsql-hackers" Subject: Re: =?UTF-8?B?QWRkIGd1YyB0byBlbmFibGUgc2VuZCBTSUdTVE9QIHRvIHBlZXJzIHdoZW4gYmFja2VuZCBl?= =?UTF-8?B?eGl0cyBhYm5vcm1hbGx5?= In-reply-to: <1a53af38-851a-4ad0-9ff1-54e7b8aeca73.mengjuan.cmj@alibaba-inc.com> References: <1a53af38-851a-4ad0-9ff1-54e7b8aeca73.mengjuan.cmj@alibaba-inc.com> Comments: In-reply-to "=?UTF-8?B?6JSh5qKm5aifKOeOiuS6jik=?=" message dated "Fri, 03 Sep 2021 15:00:00 +0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2498874.1630679973.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Fri, 03 Sep 2021 10:39:33 -0400 Message-ID: <2498875.1630679973@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "=3D?UTF-8?B?6JSh5qKm5aifKOeOiuS6jik=3D?=3D" writes: > I want to share a patch with you, in which I add a guc parameter 'enable= _send_stop' to enable set the value of SendStop in postmaster.c more conve= niently. SendStop enable postmaster to send SIGSTOP rather than SIGQUIT t= o its children when some backend dumps core, and this variable is original= ly set with -T parameter when start postgres, which is inconvenient to con= trol in some scenarios. TBH, I'd sooner rip out SendStop, and simplify the related postmaster logic. I've never used it in twenty-some years of Postgres hacking, and I doubt anyone else has used it much either. It's not worth the overhead of a GUC. (The argument that you need it in situations where you can't control the postmaster's command line seems pretty thin, too. I'm much more worried about somebody turning it on by accident and then complaining that the cluster freezes upon crash.) regards, tom lane