| From: | Wyatt Tellis <wyatt(dot)tellis(at)gmail(dot)com> |
|---|---|
| To: | Andreas Joseph Krogh <andreas(at)visena(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:10:53 |
| Message-ID: | CANCMp8yc7PBucRekbL1SGPXSAHkxRct_ntUJzTXTiMvosM6k2w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)visena(dot)com>
wrote:
> På mandag 05. februar 2024 kl. 20:55:43, skrev Wyatt Tellis <
> 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
> www.visena.com
> <https://www.visena.com>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2024-02-05 20:15:26 | Re: Improving pg_dump performance when handling large numbers of LOBs |
| Previous Message | Andreas Joseph Krogh | 2024-02-05 20:05:29 | Re: Improving pg_dump performance when handling large numbers of LOBs |