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 1qYqpd-002uJq-N1 for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Aug 2023 16:35:45 +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 1qYqpb-00EaMK-Kl for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Aug 2023 16:35:43 +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 1qYqpb-00EaM6-AQ for pgsql-hackers@lists.postgresql.org; Wed, 23 Aug 2023 16:35:43 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qYqpU-000Yee-6C for pgsql-hackers@postgresql.org; Wed, 23 Aug 2023 16:35:41 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-1c4d67f493bso4234911fac.2 for ; Wed, 23 Aug 2023 09:35:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1692808535; x=1693413335; 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=opFQPCkq36I9zsIlBrFSwr9NH+Ux/3h2w+13cxh66CU=; b=UKP844rwUq+3d2kBtt0u9TyQDOePzbuPVCi6jMW58bK0pjrO730w0nacYKcxzfGkk/ XUs0jo3Ba+jlySDDPJymTsf/TZK5/1ijUNze/WW7mtnGXfZi6S0leYX2iuVkKvd3vovO 90tY06O+n/clhnn9nr2lzmZFs68MPJxPjR4d5R16q+qMeXVPWTrfP5E2dPYasW7syN9z C2sYl8SCxeKLPdgC+H4mrE8Nz2i3h8E0ogD/9zI/8iMJQApJMqVcxusKNMMrZO3wN8Qm eoPz7itTOcFAoZuDbxaEUek58+ITxuJb4pKtQHCbShPynvc/AIFGorNBXz+ZEJVUHCb9 yeeQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692808535; x=1693413335; 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=opFQPCkq36I9zsIlBrFSwr9NH+Ux/3h2w+13cxh66CU=; b=OQWg9VhhsvRNNgPUSZRSIpHDMH3Fc9sl6cLf80yQwkgCHUeFgwf31d3yvqMnxS6joL 0cFHXpLUGvzC8uzVMmVknnVs/fdee6jAVnrqKlZ1QL0dMwPQ4HZ3HjPbQndp7ZR01cDh YGvPj+QcNS/EWrGmeHI+0ZLqPmV2rSTURD1ylZB/YR2HILHGa9R/AcdISdu/S9UOyrr+ Z/ff5ZOemxwEYQ+EqUVoL1EwwnXjXSoW02dqZ7/6h0rrYfc/faWfcKJSXpwYrPwUEFaf CoCJQ9MrFOzHR/Ql5/LajZG3GhvKRphwwLC/Mm0NN46HLl4OBKCqz87FJ0o3H074c5nw LT4Q== X-Gm-Message-State: AOJu0YxN5fo2FJsu2/8Z5KHldbHJPZEE087YekVGLFCs9gEtCWGgtXXZ Hc1wedoO+/lfScmjt/2WvP7i+qP8t0A= X-Google-Smtp-Source: AGHT+IG3wAPM1zdfBjErmnCzTP0bpHbppFg2/eGpruSfRne4H+e+gcWDpb0ILPQ8KM1UV6bV9kBOpw== X-Received: by 2002:a05:6870:3307:b0:1b0:b13:c16 with SMTP id x7-20020a056870330700b001b00b130c16mr16929302oae.2.1692808535145; Wed, 23 Aug 2023 09:35:35 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:75e2:b308:62a:6348]) by smtp.gmail.com with ESMTPSA id gq20-20020a056870d91400b001c5a3e31474sm7036520oab.45.2023.08.23.09.35.33 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 23 Aug 2023 09:35:34 -0700 (PDT) Date: Wed, 23 Aug 2023 09:35:20 -0700 From: Nathan Bossart To: Peter Eisentraut Cc: Bharath Rupireddy , PostgreSQL-development Subject: Re: add timing information to pg_upgrade Message-ID: <20230823163520.GA1064471@nathanxps13> References: <20230728173814.GA3765390@nathanxps13> <20230728184735.GC3661419@nathanxps13> <20230729211418.GA189222@nathanxps13> <20230731183702.GA537853@nathanxps13> <20230801154554.GA723589@nathanxps13> <632b1c6b-fc51-816b-4848-4063551777b0@eisentraut.org> <20230822140623.GA600331@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="PEIAKu/WMn1b1Hv9" Content-Disposition: inline In-Reply-To: <20230822140623.GA600331@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --PEIAKu/WMn1b1Hv9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Aug 22, 2023 at 07:06:23AM -0700, Nathan Bossart wrote: > On Tue, Aug 22, 2023 at 11:49:33AM +0200, Peter Eisentraut wrote: >> Let's change MESSAGE_WIDTH to 62 in v16, and then pursue the larger >> restructuring leisurely. > > Sounds good. I plan to commit this within the next couple of days. Here's the patch. I'm going to run a couple of tests before committing, but I don't think anything else is required. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com --PEIAKu/WMn1b1Hv9 Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-bump-MESSAGE_WIDTH-to-62.patch" From e2f65937666ec31004ec7668c475dd33c4ab0a91 Mon Sep 17 00:00:00 2001 From: Nathan Bossart Date: Wed, 23 Aug 2023 09:31:11 -0700 Subject: [PATCH 1/1] bump MESSAGE_WIDTH to 62 --- src/bin/pg_upgrade/pg_upgrade.h | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/bin/pg_upgrade/pg_upgrade.h b/src/bin/pg_upgrade/pg_upgrade.h index 3eea0139c7..7afa96716e 100644 --- a/src/bin/pg_upgrade/pg_upgrade.h +++ b/src/bin/pg_upgrade/pg_upgrade.h @@ -22,7 +22,7 @@ #define MAX_STRING 1024 #define QUERY_ALLOC 8192 -#define MESSAGE_WIDTH 60 +#define MESSAGE_WIDTH 62 #define GET_MAJOR_VERSION(v) ((v) / 100) -- 2.25.1 --PEIAKu/WMn1b1Hv9--