Postgres Pro
Downloads
Home   >   mailing lists

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

From Wyatt Tellis
Subject Re: Improving pg_dump performance when handling large numbers of LOBs
Date
Msg-id CANCMp8yc7PBucRekbL1SGPXSAHkxRct_ntUJzTXTiMvosM6k2w@mail.gmail.com
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  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
Tree view
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

Wyatt

On Mon, Feb 5, 2024 at 12:05 PM Andreas Joseph Krogh <andreas@visena.com> wrote:
På mandag 05. februar 2024 kl. 20:55:43, skrev Wyatt Tellis <wyatt.tellis@gmail.com>:

Yes, the LOBs themselves are tiny, but there are a lot of them (~150 million) which seem to be slowing down pg_dump.  Note, we did not design/build this system and agree that use of LOBs for this purpose was not necessary.

Well, the data is there nonetheless, is it an option to convert it to bytea before migration?

 

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-general by date:

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