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 1pjP9K-00052e-U7 for pgsql-hackers@arkaria.postgresql.org; Mon, 03 Apr 2023 18:43:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pjP9I-0008Oi-FL for pgsql-hackers@arkaria.postgresql.org; Mon, 03 Apr 2023 18:43:24 +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 1pjP9I-0008OZ-6P for pgsql-hackers@lists.postgresql.org; Mon, 03 Apr 2023 18:43:24 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pjP9F-000gHT-Cq for pgsql-hackers@postgresql.org; Mon, 03 Apr 2023 18:43:23 +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 333IhEZr1252076; Mon, 3 Apr 2023 14:43:14 -0400 From: Tom Lane To: Melanie Plageman cc: Masahiko Sawada , Daniel Gustafsson , Kyotaro Horiguchi , PostgreSQL Hackers , Andres Freund , amit.kapila16@gmail.com Subject: Re: Should vacuum process config file reload more often In-reply-to: References: <20230329.120908.350115307125624430.horikyota.ntt@gmail.com> <20230329.132155.629765142788133576.horikyota.ntt@gmail.com> <20230329.173456.1185961934810139447.horikyota.ntt@gmail.com> <935191FB-083B-4060-89FC-466F61FAA391@yesql.se> Comments: In-reply-to Melanie Plageman message dated "Mon, 03 Apr 2023 12:40:49 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1252074.1680547394.1@sss.pgh.pa.us> Date: Mon, 03 Apr 2023 14:43:14 -0400 Message-ID: <1252075.1680547394@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Melanie Plageman writes: > v13 attached with requested updates. I'm afraid I'd not been paying any attention to this discussion, but better late than never. I'm okay with letting autovacuum processes reload config files more often than now. However, I object to allowing ProcessConfigFile to be called from within commands in a normal user backend. The existing semantics are that user backends respond to SIGHUP only at the start of processing a user command, and I'm uncomfortable with suddenly deciding that that can work differently if the command happens to be VACUUM. It seems unprincipled and perhaps actively unsafe. regards, tom lane