Just checking... and I sympathize with your situation. On Mon, Feb 5, 2024 at 2:56 PM Wyatt Tellis <wyatt.tel...@gmail.com> wrote:
> 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. > > Wyatt > > On Mon, Feb 5, 2024 at 11:36 AM Ron Johnson <ronljohnso...@gmail.com> > wrote: > >> On Mon, Feb 5, 2024 at 2:01 PM Wyatt Tellis <wyatt.tel...@gmail.com> >> wrote: >> >>> Hi, >>> >>> We've inherited a series of legacy PG 12 clusters that each contain a >>> database that we need to migrate to a PG 15 cluster. Each database contains >>> about 150 million large objects totaling about 250GB. >>> >> >> 250*10^9 / (150*10^6) = 1667 bytes. That's *tiny*. >> >> Am I misunderstanding you? >> >>>
