Search Postgresql Archives

Re: Improving pg_dump performance when handling large numbers of LOBs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



På mandag 05. februar 2024 kl. 20:55:43, skrev Wyatt Tellis <wyatt.tellis@xxxxxxxxx>:

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
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux