Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNk0I-005oxG-8t for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 01:04:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qNk0G-006Wrb-EC for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 01:04:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNk0G-006WrR-3O for pgsql-hackers@lists.postgresql.org; Mon, 24 Jul 2023 01:04:48 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNk0D-00177x-4b for pgsql-hackers@lists.postgresql.org; Mon, 24 Jul 2023 01:04:46 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTPA id ECA1D60287; Mon, 24 Jul 2023 10:04:39 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.8 at oss.nttdata.com MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Date: Mon, 24 Jul 2023 10:04:39 +0900 From: Masahiro Ikeda To: Bharath Rupireddy Cc: michael@paquier.xyz, pgsql-hackers@lists.postgresql.org Subject: Re: Support worker_spi to execute the function dynamically. In-Reply-To: References: <46e53055d8d1c92704d3cd2709c722e7@oss.nttdata.com> User-Agent: Roundcube Webmail/1.4.11 Message-ID: X-Sender: ikedamsh@oss.nttdata.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2023-07-22 01:05, Bharath Rupireddy wrote: > On Fri, Jul 21, 2023 at 4:05 PM Masahiro Ikeda > wrote: >> (2) >> >> Do we need "worker_spi.total_workers = 0" and >> "shared_preload_libraries = worker_spi" in dynamic.conf. >> >> Currently, the static bg workers will not be launched because >> "shared_preload_libraries = worker_spi" is removed. So >> "worker_spi.total_workers = 0" is meaningless. > > You're right. worker_spi.total_workers = 0 in custom.conf has no > effect. without shared_preload_libraries = worker_spi. Removed that. OK. If so, we need to remove the following comment in Makefile. > # enable our module in shared_preload_libraries for dynamic bgworkers I also confirmed that the tap tests work with meson and make. Regards, -- Masahiro Ikeda NTT DATA CORPORATION