| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | Wyatt Tellis <wyatt(dot)tellis(at)gmail(dot)com> |
| Cc: | 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:05:29 |
| Message-ID: | VisenaEmail.39.b34e62cb86518e81.18d7aded876@origo-test01.app.internal.visena.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
På mandag 05. februar 2024 kl. 20:55:43, skrev Wyatt Tellis <
wyatt(dot)tellis(at)gmail(dot)com <mailto:wyatt(dot)tellis(at)gmail(dot)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
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wyatt Tellis | 2024-02-05 20:10:53 | Re: Improving pg_dump performance when handling large numbers of LOBs |
| Previous Message | Wyatt Tellis | 2024-02-05 19:55:43 | Re: Improving pg_dump performance when handling large numbers of LOBs |