Re: Improving pg_dump performance when handling large numbers of LOBs

From: Ken Marshall <ktm(at)rice(dot)edu>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: Wyatt Tellis <wyatt(dot)tellis(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Improving pg_dump performance when handling large numbers of LOBs
Date: 2024-02-05 20:32:35
Message-ID: ZcFF4xGKdAS0WLvg@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 05, 2024 at 09:17:53PM +0100, Andreas Joseph Krogh wrote:
>
> På mandag 05. februar 2024 kl. 21:10:53, skrev Wyatt Tellis <
> wyatt(dot)tellis(at)gmail(dot)com <mailto:wyatt(dot)tellis(at)gmail(dot)com>>:
>
> No, we don't have the ability to make schema changes and the schema in the
> PG15 copy needs to match what's in the PG 12 versions
>
> Well then, I guess it boils down to how badly the ones in charge wants this
> migration…
>
> --
> Andreas Joseph Krogh
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
> www.visena.com <https://www.visena.com>
> <https://www.visena.com>

Hi,

Can you use logical replication? Then you aren't under the gun to make
a fast copy.

Regards,
Ken

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-02-05 20:38:05 Re: Improving pg_dump performance when handling large numbers of LOBs
Previous Message Andreas Joseph Krogh 2024-02-05 20:17:53 Re: Improving pg_dump performance when handling large numbers of LOBs