Downloads
Home   >   mailing lists

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

From Nathan Bossart
Subject Re: Horribly slow pg_upgrade performance with many Large Objects
Date
Msg-id aHAzv9pgJh2Wa3M1@nathan
Whole thread Raw
In response to Re: Horribly slow pg_upgrade performance with many Large Objects  (Nitin Motiani <nitinmotiani@google.com>)
List pgsql-hackers
Tree view 
On Thu, Jul 10, 2025 at 06:05:26PM +0530, Nitin Motiani wrote:
> -         * pg_largeobject_metadata, after the dump is restored.
> +         * pg_largeobject_metadata, after the dump is restored.  In versions
> +         * before v12, this is done via proper large object commands.  In
> +         * newer versions, we dump the content of pg_largeobject_metadata and
> +         * any associated pg_shdepend rows, which is faster to restore.
>           */
> 
> Should the comment provide further detail on why this is only being done
> for v12 and above?

Yes.  I've fixed this in v3.

-- 
nathan
Attachment

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Explicitly enable meson features in CI
Next
From: "David E. Wheeler"
Date:
Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part