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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sXPqk-003uCx-FK
	for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jul 2024 18:39:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sXPqi-00GOs0-VE
	for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Jul 2024 18:39:28 +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 <nathandbossart@gmail.com>)
	id 1sXPqi-00GOrA-LH
	for pgsql-hackers@lists.postgresql.org; Fri, 26 Jul 2024 18:39:28 +0000
Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1sXPqg-001b5U-6s
	for pgsql-hackers@postgresql.org; Fri, 26 Jul 2024 18:39:27 +0000
Received: by mail-io1-xd2f.google.com with SMTP id
 ca18e2360f4ac-81f9339e544so20344139f.0
        for <pgsql-hackers@postgresql.org>;
 Fri, 26 Jul 2024 11:39:26 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1722019165; x=1722623965;
 darn=postgresql.org;
        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=Ah9EvTA2nRjuq6dhL0tYQnBxkeZB3iJXjpeoHk6uh98=;
        b=YErGTVcdC9X3HsdZpeMxBXuPry2onAaoNM6KkncyVTS0+guBRw+NUPqRdEf2uEFM90
         kz2MeBh6N0b9Rf6SRYfJu2sV9nI4t7wehVBmwcPoWEBB79n0PfHi4mdZRVOrl2r5EeUZ
         fsE2ur2pfXdcRcGvZqOf+kPBQwc+26uiYUg7pnyBe01SggfmoaA3TStufTICtb+v4cxP
         rh21L4H0UjUh8NgWjNaVxYQyVW9U8i8GPIRIkohc+JaM/xT1y+BEmQJoxIyzkko/xrPf
         xp40BvX1Z/4cvdJoicLIZlWG3KUr/hZuzTuyYT+MaacfUt6G19vBBR6rKkFtLkmoB6lK
         gA8w==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1722019165; x=1722623965;
        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=Ah9EvTA2nRjuq6dhL0tYQnBxkeZB3iJXjpeoHk6uh98=;
        b=gj+SWTO2whu4R1pCGF3z9PMKWgRpcVMGJn+zFoFGNzzj+2Gh5UVKRf/ANGcc6PK6XD
         P74w5EeGbTTLW15K+risCFMnA95Ifu9kxJFGycTlU/5BCdEW/LVNvFhjXP11pGOM5Dz1
         MnsCsmdiUsTD3d0c1gSZcCybYwfcqje4p78oXWODNGGJUGcQ97VNxdmJuEVFKWByR2tn
         t/ndFoBuRvarm67hhJjLnPHQwarfSkXjX1vq7JjQNr37TKAFh2d5/9VXJ63w0AARWgPF
         vKrKbHDkBa2IEnUFGHFBlGTFQcdLM2NkJf87e4oZ06oF7Q8ZCRxN7BlfoQm9TiWkwW3q
         BXTA==
X-Forwarded-Encrypted: i=1;
 AJvYcCUQ+OCaLoUKsLmhMBqMC4xOSDbZ+n5Yl+SP0AVmbGdPSDHE7WfCe4X5wfGNOH7ZBQpqp3A2cylHzo3RRFKL23QJH0pbMzCPrAb86VFk
X-Gm-Message-State: AOJu0YwDv1DJm7xJzmSN3NO4vOnfYjfHTBsw4UH4vOqvw2MfoNLoD8Uv
	ZaidFwz9J/9/lM9N9q99EWWFhsaS3WrtHetMWLsRqq0Nbh9t299dXnRnVg==
X-Google-Smtp-Source: 
 AGHT+IHlT8rViNCVXVpkk0O6sYuL4wC/2mVOFCYaTLm9N5d2y47KYRTdj03NKjEcQy+DyPHFyUdI5Q==
X-Received: by 2002:a05:6602:4741:b0:7f6:1cb2:8027 with SMTP id
 ca18e2360f4ac-81f95e4c603mr37678039f.17.1722019165413;
        Fri, 26 Jul 2024 11:39:25 -0700 (PDT)
Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net.
 [162.195.168.172])
        by smtp.gmail.com with ESMTPSA id
 8926c6da1cb9f-4c29fa941f0sm960306173.41.2024.07.26.11.39.24
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 26 Jul 2024 11:39:25 -0700 (PDT)
Date: Fri, 26 Jul 2024 13:39:23 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Robert Haas <robertmhaas@gmail.com>, Jeff Davis <pgsql@j-davis.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: optimizing pg_upgrade's once-in-each-database steps
Message-ID: <ZqPtWyzijygbJ874@nathan>
References: <ZoMK9ZhOsWEKqxlM@nathan>
 <ZowEIGd0lLKh16qe@nathan>
 <ZoyveaS6a6jyhYS6@nathan>
 <26742670-9539-4F30-B6FA-9C1DB743BC23@yesql.se>
 <Zpg4WnS9BRWbgBLi@nathan>
 <4493D323-9726-48F7-A702-E71FB991F76B@yesql.se>
 <ZprY4e23vR95Nc51@nathan>
 <Zp677slGLwhPhVWy@nathan>
 <ZqG_bBb7cvjFPRvm@nathan>
 <6633BF53-C2AC-4438-A1B5-24D4AF51C221@yesql.se>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <6633BF53-C2AC-4438-A1B5-24D4AF51C221@yesql.se>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/ZqPtWyzijygbJ874%40nathan>
Precedence: bulk

On Thu, Jul 25, 2024 at 11:42:55AM +0200, Daniel Gustafsson wrote:
>> On 25 Jul 2024, at 04:58, Nathan Bossart <nathandbossart@gmail.com> wrote:
>> Here is just the live_check patch.  I rebased it, gave it a commit message,
>> and fixed a silly mistake.  Barring objections or cfbot indigestion, I plan
>> to commit this within the next couple of days.
> 
> LGTM

Thanks, committed.

-- 
nathan