Re: Improving pg_dump performance when handling large numbers of LOBs - Mailing list pgsql-general

From Ken Marshall
Subject Re: Improving pg_dump performance when handling large numbers of LOBs
Date
Msg-id ZcFF4xGKdAS0WLvg@aart.rice.edu
Whole thread Raw
In response to Re: Improving pg_dump performance when handling large numbers of LOBs  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: Improving pg_dump performance when handling large numbers of LOBs  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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.tellis@gmail.com <mailto:wyatt.tellis@gmail.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@visena.com <mailto:andreas@visena.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



pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Improving pg_dump performance when handling large numbers of LOBs
Next
From: Tom Lane
Date:
Subject: Re: Improving pg_dump performance when handling large numbers of LOBs