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.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wi5EB-0000QZ-0P
	for pgsql-bugs@arkaria.postgresql.org;
	Fri, 10 Jul 2026 07:00:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wi5E9-00GSIu-1l
	for pgsql-bugs@arkaria.postgresql.org;
	Fri, 10 Jul 2026 07:00:50 +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.96)
	(envelope-from <huseyin.d3r@gmail.com>)
	id 1wi5E9-00GSIm-10
	for pgsql-bugs@lists.postgresql.org;
	Fri, 10 Jul 2026 07:00:50 +0000
Received: from mail-oi1-x236.google.com ([2607:f8b0:4864:20::236])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <huseyin.d3r@gmail.com>)
	id 1wi5E8-00000000R9b-0bEv
	for pgsql-bugs@lists.postgresql.org;
	Fri, 10 Jul 2026 07:00:49 +0000
Received: by mail-oi1-x236.google.com with SMTP id
 5614622812f47-4a40bcc8d69so431069b6e.3
        for <pgsql-bugs@lists.postgresql.org>;
 Fri, 10 Jul 2026 00:00:48 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; t=1783666848; cv=none;
        d=google.com; s=arc-20260327;
        b=ghG0As5eEw0VjSvjnZ9Vzn1L+dTBD9oomI4qOtYYsh0JdolTb//DMux56IbjsTFXVS
         OU7wWi8+eMekYDl4SPGJOvZ6kfX58GDqWMeaMXAyiEgtjs4Qj/F0tLQZbpOnhWQGxPzG
         rJvYhodaXTY2iI1VKdQATDIN0xFRyVePLF+Zuvopvr5tSHcGzlGD2GdhhiNK9SY2tDFM
         hLNOSd9aLeVdenzilZc0G+1gkbojRn+b9EwVE6iCGu9/CPVxqGQdQM0W2SMdeG+NQaKn
         90LBAuTFR/94K8RvLBQ0Eww4YCH0LhWk1WB8zyUbPzkVg66OwNUiNx50RL58Sm2kYNsw
         plXg==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;
 s=arc-20260327;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:dkim-signature;
        bh=++XP/WgVztyfUJlrx/FVfvbUVpoBgkoWZBqf5PJRhQg=;
        fh=UYWGJoCAr3OEHYHn6eQccYCZcNPjDltdov+DokavRzI=;
        b=HAb1SlfamZ7uIqX55M72Q879nescosQALpW3+kKyxxdY56aF/5z/5BzfiWDGZX9No/
         btzhK8eNGbFframBcxMGV7hEuDV0JTTpMzEW5Y/NYwYzptdyQ1N2iqsc0fC2rJ6WIiae
         hKlx8/7x020H4WZlOFbRSx3AU8jbJ02a6giYjXS2licglx08fxVNJ55IhcQad9Hof5ei
         2VxNpO4m0kEx7TUobyknRQr+vHLirz2iIS8WAxcmGJCd/tziFypS95G/351bElSd1cpl
         t6tSHez0F/AZKHEA22NrvdSRNWBFS92gudq+hyLnnLwy3tDKzqHKyPHLiJdlZlUoT2TD
         QBxQ==;
        darn=lists.postgresql.org
ARC-Authentication-Results: i=1; mx.google.com; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20251104; t=1783666848; x=1784271648;
 darn=lists.postgresql.org;
        h=content-type:cc:to:subject:message-id:date:from:in-reply-to
         :references:mime-version:from:to:cc:subject:date:message-id:reply-to
         :content-type;
        bh=++XP/WgVztyfUJlrx/FVfvbUVpoBgkoWZBqf5PJRhQg=;
        b=owwOhWOQLabat90IKsBj6HIr9HSxYomy7Lcc3x+pFTizbjmSBj2UVYXIHcV8O0xqkG
         yON4kJ9SteYB1oVIyVgV8LPFyOsTFwh8Gk5w19kR5MyOfVNPETiqubgf228JbCGs5q6s
         TMgyvQE6UEForkrHZR/s/jlSMX6ehmk3w5/tQH1sZg6zwI+s8rlnarb5GNlHDDZ8H+u5
         tbS8EGQGL19HRb1DWdgJfPJBqe9NX7Mb2d3Xwg6GVlKqqnB9kmV0ClkjUbLbM2kkQogm
         EtSGQhWEYhteDKSSrJ5pS+KJi7ublbNnmpy4e2CRhjmUQ0NtwXSJk4Jwdhvo99xyYSW0
         62qA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1783666848; x=1784271648;
        h=content-type:cc:to:subject:message-id:date:from:in-reply-to
         :references:mime-version:x-gm-gg:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to:content-type;
        bh=++XP/WgVztyfUJlrx/FVfvbUVpoBgkoWZBqf5PJRhQg=;
        b=BHfiPQYmwjJVhQF3icQOnMQNDmgbR6G9r+IOgopWq1barRv5FQqIj4rjLlVWU9ARk3
         vonFIdUNzTh9fJSA1vw0/wkrfP4/Nq1x97/gU0ZQWtxZx6H6Q9MzLe7RXL4qxyBiDngn
         SHYAyZ9ow+vNhzn3yoB9Mrha+9+FgcczVmrh6E6CSQDbVL4ZjQf+qE3jQwz759PQ4rt8
         uiKuwPGYpDzg2c7+n8TnCZ98lq1iRONnw00wL2dMi5v4NXakGgXNbR0CpMBTQ+Yb0ZXr
         l4a8Q73Z0Mlt8G/eL29ZM2wU388T8Gy5EdvNmrumI7ozu+K8DIN26qNYw6Fo8HYqRalR
         Mh9g==
X-Forwarded-Encrypted: i=1;
 AFNElJ9o4qDO+MhepU6xq4IYQLn08zPbbYYVRnlZCFQC87/E8cmsqCoJcBel4CwzFc8Tt9Gev0fs9CFVv0RR@lists.postgresql.org
X-Gm-Message-State: AOJu0Yx6rpRDlHc23ZrX6Yt4qQUEYSV/erIq5Tbvg5pQlSZ85Y7pkw1G
	X6OrsciaKTsunmuV9VCth6v1CsypgrWTZsUUkrrk8l9x/8bjnyWtKtvJkBrV/dGjYPRWhx26eB2
	6IGbjOaaLrM6DtCPeFM3etaF8OFRMSFk=
X-Gm-Gg: AfdE7clEGTp+z03PE14Xl8KSp0qJ2STWu1uJ5xpYsvZZdN4P329ByJ6BeMhSTH04wUm
	2rKg9SB6nUPDB4UMDjZi7SEczNm5j0IhbN3yn1pO+FBKuTNDrkSCxYMMvynOBzmYyG3WHwopv/+
	+zm24B7HClLZM2rXFlSrIBs9coIk4umnkKSCFiN8WAi7pGz9TPdSU+Whcd778JSjdy0uutB1TNO
	bbeAnwArvieezBUPSwogWw3uii+l7bOrIvoPPv9Xs2zUeGVjnfzfQ2tuLBFd/YNqO8uBKqUnK44
	XQWLWFq4GD6Lk659/ZIMhu9k3+sAzH4v4vBzytQmLt7ODn68aJhhLxWrXePr8T1WwaKbaPPGeNq
	Jy8ZWph3x3sEq9nDD
X-Received: by 2002:a05:6808:c3e9:b0:494:92ec:3525 with SMTP id
 5614622812f47-4a204ce5904mr7042182b6e.36.1783666847666; Fri, 10 Jul 2026
 00:00:47 -0700 (PDT)
MIME-Version: 1.0
References: <19483-80de42dc4e62cfd6@postgresql.org>
 <CAKAnmmLYXcBSV8i5MVuiwu8tkX-JDGmZtJ38_YbdUTwoDW7xKg@mail.gmail.com>
 <104812.1780847519@sss.pgh.pa.us>
 <CAB5wL7bo-7okBCJ24fdVn4UhnuPLPG22eQjaLJZ9GJtv0FEWMg@mail.gmail.com>
 <CAB5wL7bunPCi93Bwi7zN_1gFAZhKLwS=Fsub91SW417xujGtNA@mail.gmail.com>
 <CAB5wL7aKGFFEF1SM54GxvaQPH=7Bs=HuUCqi7F4Ve025+Z950A@mail.gmail.com>
 <CAB5wL7aK6UaukMSegzEG68y0VrKOg7wFnPNRaDaHreBf2iVWag@mail.gmail.com>
 <d305af372949be0c2c4155168ca7ba97e160bc52.camel@cybertec.at>
 <5184088806e70ed5db7e83bd6540a016b3802c1d.camel@cybertec.at>
 <CAB5wL7ZuFwu2Sd-xmn-w5-BbrKk_Mu_1ubYow_qaqFGhJOiMXw@mail.gmail.com>
 <CAB5wL7ai8AiaFV6B8J=w6vK1Q6Z9Hmp_y3PFL2Zzpx6Y8xPZ2A@mail.gmail.com>
 <0d7531c192859057c6aad54c89a8d453376bd00c.camel@cybertec.at>
 <592839.1782153054@sss.pgh.pa.us>
 <CAB5wL7btFp-XRBfv_J-YperoK+e0uYje3ZYsfTzCuHcUWWrvbw@mail.gmail.com>
 <CAB5wL7YFeL0VP7EZu6wtWx=UhXuDp3dTBVJwFvSRzBi7qNscfQ@mail.gmail.com>
 <f55bf7dc0a503f82abfb6f02ac91278fe59d40d9.camel@cybertec.at>
 <CAB5wL7Zy89DeVXHFvTL72KChkq=2jLXhH14zrC2n5sutLTqZDg@mail.gmail.com>
 <daee495807e183ea6f48c3c0844239753d7f9f6d.camel@cybertec.at>
 <CAB5wL7YQs7CDduxx0cv3iKPnQ7fxT-mj0AqPWv2WPO3aaF_VeQ@mail.gmail.com>
 <dc65b5171cfb7031e964bedc2d08affbdbf11053.camel@aon.at>
 <ec8f6c8008cf88577b14489b68fef971f16960ab.camel@aon.at>
In-Reply-To: <ec8f6c8008cf88577b14489b68fef971f16960ab.camel@aon.at>
From: =?UTF-8?Q?H=C3=BCseyin_Demir?= <huseyin.d3r@gmail.com>
Date: Fri, 10 Jul 2026 09:00:35 +0200
X-Gm-Features: AVVi8CfHdXEGeANQndYa23lo4d3ZTsba3Ymq44GO0Uy78BQhwf18aZ6jrbmJgQA
Message-ID: 
 <CAB5wL7Y5WPpyfFQ0aLQhtNqDQucOMw+TvCC-noG4u=o=mnqtGQ@mail.gmail.com>
Subject: Re: BUG #19483: pg_upgrade fails with orphan records in pg_init_priv
 catalog table
To: Laurenz Albe <laur@aon.at>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Greg Sabino Mullane <htamfids@gmail.com>,
	pgsql-bugs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/CAB5wL7Y5WPpyfFQ0aLQhtNqDQucOMw%2BTvCC-noG4u%3Do%3DmnqtGQ%40mail.gmail.com>
Precedence: bulk

> > I'd say that your v6 patch is fine if the performance impact can be
> > shown to be small.
>
> To keep the ball rolling, I ran a pg_upgrade --link from a debug-enabled
> build on a database with 20000 empty tables.
>
> pg_upgrade took between 19 and 25 minutes, and I saw no noticeable effect
> of the patch.  So I guess this is good to go.
>
> Yours,
> Laurenz Albe

Thanks for the pg_upgrade test.

Appreciated.