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 1qgQbD-00Fnqs-QM for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Sep 2023 14:12:11 +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 1qgQbC-000IBQ-IJ for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Sep 2023 14:12:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgQbC-000IBF-7r for pgsql-hackers@lists.postgresql.org; Wed, 13 Sep 2023 14:12:10 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qgQb8-004r6s-Jj for pgsql-hackers@lists.postgresql.org; Wed, 13 Sep 2023 14:12:09 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 717CB3200948; Wed, 13 Sep 2023 10:12:04 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 13 Sep 2023 10:12:04 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to; s=fm1; t=1694614323; x=1694700723; bh=GFbXaEtL5mlTTKoz3X6hpEBN5 yBJ10R5TNhTgofYCKY=; b=PlQNtQVckEBbPUofjeWSFdCIGlQOuTgmsoL2Dvyes OvRFWXRg5bJapWAut2Ylo820GaV7JekuOQwsqn2orwjDRhrBOQifsPSh6UvBX1wW C6BrDFplaa6K9r7nWe2r0UCrzSOL81qKcDllrDucmJ2gy40auD628hCMD2He0mfI qaUYxeWbhezL7eAd41tLW+wTqU91BC28gxT5OQR9c0LAzSGFwhspAmE7IeipcIfd lVHAqkcLiv9BRhpqD0lW+Tc4a/Ux02BQkFUsYWUiJSEqagONmrXJNFVOrQ+J527x yNT6n1SP2QmIp51YkYbxfaO8k9ehX0vZPZ/8f5saIZP9g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1694614323; x=1694700723; bh=GFbXaEtL5mlTTKoz3X6hpEBN5yBJ10R5TNh TgofYCKY=; b=Pa2lzMcXu6OuMiuBh5HTx59VXcBKkz1DA1I3qq6ZQYxQQuL1ua6 M/jPxbOCPXBcNjup3N6JjC2MJ5QMMZETqURc01cPs8XwbxEvoVRvnYXHMpQfiCF6 fWFMyTC9+bJ4BzVJlVQEJ2iC15k7ZTl0RMy4YQ3Cc2X5u3y7xBovybqIc0GeXnYg lVKRMS7rI3f4OAXqDlyIgjLWujtnL4we33ma78oxIlmr46/cA+XMxc8IkfPhAFmT lGY9+MzVJA7T198XDnQS580/sEOCdZtk7Ab8d98F/+lwGv7NsSB16T48nHjL+XeC 1WBI/5tRmg+Lj69RsfhkDIjIU3skXuc6OfA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudeikedgjeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgh eqnecuggftrfgrthhtvghrnhepheeiuefhleelfeeikeehkefgkeeggfevheeuvdejveet tdegleekffffieekuedtnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhg X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 13 Sep 2023 10:12:02 -0400 (EDT) Message-ID: Date: Wed, 13 Sep 2023 16:12:02 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.15.0 Subject: Re: Reducing connection overhead in pg_upgrade compat check phase Content-Language: en-US To: Daniel Gustafsson , Nathan Bossart Cc: PostgreSQL Hackers References: <235E7E38-6DCA-4E5F-812C-7F3033FC800A@yesql.se> <89A64E5D-D3DC-4806-B038-CD493F5F5510@yesql.se> <20230313182147.GA294021@nathanxps13> <20230704190839.GA3468243@nathanxps13> <9C9D8A09-9794-46DD-8074-8961924B99F1@yesql.se> <20230708214354.GA4044380@nathanxps13> <20230710230907.GA481155@nathanxps13> <1FE28680-333E-433C-9809-95662037B0AA@yesql.se> <22CDC82E-8959-4D92-B1B0-069558011F1C@yesql.se> <20230711233606.GA776188@nathanxps13> <19245526-3F25-4F84-BB80-21DA034F8650@yesql.se> From: Peter Eisentraut In-Reply-To: <19245526-3F25-4F84-BB80-21DA034F8650@yesql.se> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 31.08.23 23:34, Daniel Gustafsson wrote: >> On 12 Jul 2023, at 01:36, Nathan Bossart wrote: >> >> On Wed, Jul 12, 2023 at 12:43:14AM +0200, Daniel Gustafsson wrote: >>> I did have coffee before now, but only found time to actually address this now >>> so here is a v7 with just that change and a fresh rebase. >> >> Thanks. I think the patch is in decent shape. > > Due to ENOTENOUGHTIME it bitrotted a bit, so here is a v8 rebase which I really > hope to close in this CF. The alignment of this output looks a bit funny: ... Checking for prepared transactions ok Checking for contrib/isn with bigint-passing mismatch ok Checking for data type usage checking all databases ok Checking for presence of required libraries ok Checking database user is the install user ok ... Also, you should put gettext_noop() calls into the .status = "Checking ..." assignments and arrange to call gettext() where they are used, to maintain the translatability.