Thread

Re: Horribly slow pg_upgrade performance with many Large Objects

Hannu Krosing <hannuk@google.com> — 2025-07-21T00:03:45Z

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