Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Improving pg_dump performance when handling large numbers of LOBs
Date
Msg-id CANzqJaBE39Kx3e5TUa-Fxkrkeu4EQMg_K-rzdNPFzjccq=gO=Q@mail.gmail.com
Whole thread Raw
In response to 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  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Improving pg_dump performance when handling large numbers of LOBs  (Wyatt Tellis <wyatt.tellis@gmail.com>)
Re: Improving pg_dump performance when handling large numbers of LOBs  (Shaheed Haque <shaheedhaque@gmail.com>)
List pgsql-general
Tree view
On Mon, Feb 5, 2024 at 2:01 PM Wyatt Tellis <wyatt.tellis@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?

pgsql-general by date:

Previous
From: veem v
Date:
Subject: Re: How to do faster DML
Next
From: Adrian Klaver
Date:
Subject: Re: Improving pg_dump performance when handling large numbers of LOBs