Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Joseph Krogh
Subject Re: Improving pg_dump performance when handling large numbers of LOBs
Date
Msg-id VisenaEmail.39.b34e62cb86518e81.18d7aded876@origo-test01.app.internal.visena.net
Whole thread Raw
In response to Re: Improving pg_dump performance when handling large numbers of LOBs  (Wyatt Tellis <wyatt.tellis@gmail.com>)
Responses Re: Improving pg_dump performance when handling large numbers of LOBs  (Wyatt Tellis <wyatt.tellis@gmail.com>)
List pgsql-general
Tree view
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: Wyatt Tellis
Date:
Subject: Re: Improving pg_dump performance when handling large numbers of LOBs
Next
From: Wyatt Tellis
Date:
Subject: Re: Improving pg_dump performance when handling large numbers of LOBs