Re: improve performance of pg_dump --binary-upgrade

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: improve performance of pg_dump --binary-upgrade
Date: 2024-04-18 06:08:28
Message-ID: CADkLM=fDR9msTafzrmm==aoNu6FvTj4OZxphmODHjU_zxW5A3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> One downside of this approach is the memory usage. This was more-or-less
>
>
Bar-napkin math tells me in a worst-case architecture and braindead byte
alignment, we'd burn 64 bytes per struct, so the 100K tables cited would be
about 6.25MB of memory.

The obvious low-memory alternative would be to make a prepared statement,
though that does nothing to cut down on the roundtrips.

I think this is a good trade off.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2024-04-18 06:09:41 Re: Disallow changing slot's failover option in transaction block
Previous Message Japin Li 2024-04-18 06:07:22 Re: Cannot find a working 64-bit integer type on Illumos