Date: Fri, 18 Jul 2025 11:05:04 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Nitin Motiani <nitinmotiani@google.com>,
	Hannu Krosing <hannuk@google.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Horribly slow pg_upgrade performance with many Large Objects
Message-ID: <aHpwsGXSicLArZSk@nathan>
References: <aG6srPib60NzJBeg@nathan>
 <CAMT0RQRT3KkwoQkx=YBdd_o9SqXxOt16fqQsscH_n+40Z57N7w@mail.gmail.com>
 <CAH5HC942o6j1qyVysiBtO+Vpb=XOBPbf3rKqsOLtpDpp0SzjkA@mail.gmail.com>
 <aHAzv9pgJh2Wa3M1@nathan>
 <CAH5HC94tYpgCnoPRYbCGQU0eCM8D7X+aEmB0GZrhjR16JEe5_A@mail.gmail.com>
 <aHEk_JEoNhIpuHd-@nathan>
 <CAH5HC96=3NjeYA5vuj8CyMmiFhU27jgvQ9WgXbUDccrE7xvwYw@mail.gmail.com>
 <aHUvLi_sdfBrxzYh@nathan>
 <700576.1752514083@sss.pgh.pa.us>
 <aHVDmAqcwanTAGZa@nathan>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <aHVDmAqcwanTAGZa@nathan>
Archived-At: <https://www.postgresql.org/message-id/aHpwsGXSicLArZSk%40nathan>
Precedence: bulk

Committed.

I'm cautiously optimistic that we can find some better gains for upgrades
from v16 and newer.  That would involve dumping lo_create() commands for
all LOs with comments/seclabels, dumping the relevant pg_shdepend rows, and
then copying/linking the pg_largeobject_metadata files like we did prior to
v12.

-- 
nathan