Re: Horribly slow pg_upgrade performance with many Large Objects - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Horribly slow pg_upgrade performance with many Large Objects
Date
Msg-id CAMT0RQQmc5KKCYUG4Qa1R2L-Yar=7p_pEROLrEy_SSNkG6eRNw@mail.gmail.com
Whole thread Raw
In response to Re: Horribly slow pg_upgrade performance with many Large Objects  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Horribly slow pg_upgrade performance with many Large Objects
List pgsql-hackers
Do you think the current patch could be backported to at least some
latest versions ?

On Fri, Jul 18, 2025 at 6:05 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
>
> 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



pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX
Next
From: Hannu Krosing
Date:
Subject: Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)