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 1ppbdn-0000iK-5r for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Apr 2023 21:16:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppbdk-00082X-8l for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Apr 2023 21:16:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppbdj-00082N-Sn for pgsql-hackers@lists.postgresql.org; Thu, 20 Apr 2023 21:16:27 +0000 Received: from mail-pf1-x430.google.com ([2607:f8b0:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ppbdd-000wd2-5P for pgsql-hackers@postgresql.org; Thu, 20 Apr 2023 21:16:26 +0000 Received: by mail-pf1-x430.google.com with SMTP id d2e1a72fcca58-63b73203e0aso10050480b3a.1 for ; Thu, 20 Apr 2023 14:16:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1682025380; x=1684617380; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=O7Gervl87WbEXBR/Avrr+hT11rY3eJPcFc8Mnias6a0=; b=Pjp2+w41d6Y/pVmtD01x/UJZIEUJnKF2mNurQWzHTo5PXzLnrjod0Mh5iDNxTB5aY9 fndUrnHx/LLWdGa3aPCC+9xgq/rD/9kEn5kML03bJHSI68E5TgXD8S4a6atYg0zAwV76 d5DER61hPeSIBssCtOI5JbbfnJa8bgcZxOLWt87Zylod0ryiKi0tFXzZRpywXUQ5Yd6L Ky9EICwdfKlD+iaGewl4L+f76LBnSyH+JwMK3ACiNWjUZjI+ejAzngyqkX60aGaWaGbN Buem61BoM0A68ZVCytvlQDhBR4YEHYQf53Q3pNQnIz0kdzLDMSExwetng5axRnoa3Glj Yu2Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682025380; x=1684617380; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=O7Gervl87WbEXBR/Avrr+hT11rY3eJPcFc8Mnias6a0=; b=GzXlrU9YQcRcZQ6IW+jIEcLg117ArOy1Yy+/8pRGfaa9IWjJVHAkuOH35Yyelb4i/I is5wsPY3aVhFf3f7RNoCMnGeoCG5pGbSEWxhLx+021s3cUVotWG0cnb+mvRCfcro5p6d pH006zqfpgD+EIBlIkFDjlxsCY4IC3OXJy38BURCH6UIM1dmhNd5auhlYIgub3hdJi+y bnhZwjeINlOOszp3jxNN16KUFoEkrsrMf6loJ7D1AlAGXHJFfXTDLpEUlBJmPURZxmrf 0YoLFmEzaPJ6IXsguUFj+huJ9r8WzLmE6xu0CShaLTHGKp2cbk/BQCWTANgqnMMfF7s0 u/MA== X-Gm-Message-State: AAQBX9c2XIRbq4R5QPJZd6IhhGW0Xo4Bl3DtnJ7SVSgHRMg00IeDPwf+ lGsqWr1bKS+TRQqSt+wjDz8= X-Google-Smtp-Source: AKy350avv0mohB5tyNIviRHmTPq2CBekIrrejGXpCzkEKl5vi0MAWtWAaf6EBYVT06iK5ZtsEiaX4g== X-Received: by 2002:a17:90a:6e45:b0:246:fbf2:7e6e with SMTP id s5-20020a17090a6e4500b00246fbf27e6emr3280075pjm.14.1682025380224; Thu, 20 Apr 2023 14:16:20 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id o4-20020a170902778400b001a2135e7eabsm1554857pll.16.2023.04.20.14.16.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Apr 2023 14:16:19 -0700 (PDT) Date: Thu, 20 Apr 2023 14:16:17 -0700 From: Nathan Bossart To: Michael Paquier Cc: Justin Pryzby , Kyotaro Horiguchi , sfrost@snowman.net, alvherre@alvh.no-ip.org, andres@anarazel.de, jchampion@timescale.com, john.naylor@enterprisedb.com, masao.fujii@oss.nttdata.com, noriyoshi.shinoda@hpe.com, pgsql-hackers@postgresql.org, rjuju123@gmail.com, sawada.mshk@gmail.com, tgl@sss.pgh.pa.us, thomas.munro@gmail.com Subject: Re: Improve logging when using Huge Pages Message-ID: <20230420211617.GA1435672@nathanxps13> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Mar 23, 2023 at 07:23:28AM +0900, Michael Paquier wrote: > On Wed, Mar 22, 2023 at 05:18:28PM -0500, Justin Pryzby wrote: >> Wow, good point. I think to make it work we'd need put >> huge_pages_active into BackendParameters and handle it in >> save_backend_variables(). If so, that'd be strong argument for using a >> GUC, which already has all the necessary infrastructure for exposing the >> server's state. > > I am afraid so, duplicating an existing infrastructure for a need like > the one of this thread is not really appealing. AFAICT this would involve adding a bool to BackendParameters and using it in save_backend_variables() and restore_backend_variables(), which is an additional 3 lines of code. That doesn't sound too bad to me, but perhaps I am missing something. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com