Message-ID: <ec8f6c8008cf88577b14489b68fef971f16960ab.camel@aon.at>
Subject: Re: BUG #19483: pg_upgrade fails with orphan records in
 pg_init_priv catalog table
From: Laurenz Albe <laur@aon.at>
To: =?ISO-8859-1?Q?H=FCseyin?= Demir <huseyin.d3r@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Greg Sabino Mullane <htamfids@gmail.com>,
	pgsql-bugs@lists.postgresql.org
Date: Thu, 02 Jul 2026 23:09:54 +0200
In-Reply-To: <dc65b5171cfb7031e964bedc2d08affbdbf11053.camel@aon.at>
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>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/ec8f6c8008cf88577b14489b68fef971f16960ab.camel%40aon.at>
Precedence: bulk

On Fri, 2026-06-26 at 10:30 +0200, Laurenz Albe wrote:
> 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