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 1q8pE5-0003db-1m for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Jun 2023 21:37:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q8pE3-0002Dy-Va for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Jun 2023 21:37:23 +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 1q8pE3-0002Dp-Kf for pgsql-hackers@lists.postgresql.org; Mon, 12 Jun 2023 21:37:23 +0000 Received: from mail-pf1-x42b.google.com ([2607:f8b0:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q8pE0-001r7O-RF for pgsql-hackers@postgresql.org; Mon, 12 Jun 2023 21:37:22 +0000 Received: by mail-pf1-x42b.google.com with SMTP id d2e1a72fcca58-6642e056d7fso1788990b3a.1 for ; Mon, 12 Jun 2023 14:37:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1686605840; x=1689197840; 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=C5EPuCfb4LW1nd+5HKPuRZVlSaJ4J4u1svZux+6GRkg=; b=ij+5Rcbv7LNkN3gJF8QHe6IenJ+QxQBp06PXUyDLQuDm2COlwG4Y9/dxMYZxkTgpaw lIezqi10oH9QFrZAl4mQ38bPI7VGyY7eiYrHW2ToefdzKTU1DOGustb1F6MOUJvqoWnU F1COTb13FQCFItqe73tgJR8GizY5RzYuNv+devZR7kx48dC9qFfJSzLwm3/1PpKpwNvk mEv9b5J+vt/Hg36Fx9MrmH6cm7sw6YN161HhVL/Nz0c7/FVynIhMd7it7ZmMtod76kEN f7GR4a1DueB+evNiut+AqAFry5wC0YT9+L10Gd4x8DD446dF/ePXx71yxp3pTevTVznU ExNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686605840; x=1689197840; 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=C5EPuCfb4LW1nd+5HKPuRZVlSaJ4J4u1svZux+6GRkg=; b=H2JVwLw2R4M1lJ4Z5F+dyK0VlBkgo7C+T/8PfG0V2rRruqrAxIMLzXFJzergPisA27 ejwj94ZgQQMxgbdExAp47mHQpZhCK1gcLAh9OpXfe2lUMOQSsKSg7/O4FWF2U7fPOZLA O2CieABSBZGWVqkfhLJjjpxqtpRvM4PCo533K2anc+bmK8ufGB5V/gfYdmKupMSRQBXL agXmfDtFqxJ7dTge5d0DLLfWqF2tPFHopsHVMxtF6dn0aTIBpAISlLV7JnctUmJ52ids VeZGN4B0pQUE0nE3sKYvaY7PWYn5khzYR1f1RmUgcCzx7yJfl74WNedEoBAwANL+G92u 00Gg== X-Gm-Message-State: AC+VfDxL4w1WItU3j2RiQUJXleM4WR/tK/9mh5ghmTXiIygrtipf5E4z KAdxHtABd97X6fUf3eMF4ek= X-Google-Smtp-Source: ACHHUZ45Gt+SSjoHDcM7dw0TUx9gGC3ZgU22JZJOdD2KcZpcrqAzuRW6XV1TZVA7PLTYdCuZnOd4vQ== X-Received: by 2002:a17:90a:42:b0:25b:ce26:8fc2 with SMTP id 2-20020a17090a004200b0025bce268fc2mr4857001pjb.40.1686605839739; Mon, 12 Jun 2023 14:37:19 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id u14-20020a17090a5e4e00b0025bce91c226sm3242314pji.49.2023.06.12.14.37.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 12 Jun 2023 14:37:19 -0700 (PDT) Date: Mon, 12 Jun 2023 14:37:15 -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: <20230612213715.GA178071@nathanxps13> References: <20230420211617.GA1435672@nathanxps13> 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 Tue, May 02, 2023 at 11:17:50AM +0900, Michael Paquier wrote: > On Thu, Apr 20, 2023 at 02:16:17PM -0700, Nathan Bossart wrote: >> 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. > > Appending more information to BackendParameters would be OK, still > this would require the extra SQL function to access it, which is > something that pg_settings is able to equally offer access to if > using a GUC. Fair enough. I know I've been waffling in the GUC versus function discussion, but FWIW v7 of the patch looks reasonable to me. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com