Re: Improving pg_dump performance when handling large numbers of LOBs

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "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 19:35:47
Message-ID: CANzqJaBE39Kx3e5TUa-Fxkrkeu4EQMg_K-rzdNPFzjccq=gO=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 5, 2024 at 2:01 PM Wyatt Tellis <wyatt(dot)tellis(at)gmail(dot)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?

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-02-05 19:53:27 Re: Improving pg_dump performance when handling large numbers of LOBs
Previous Message veem v 2024-02-05 19:24:35 Re: How to do faster DML