Re: pg_bulkload slowing down

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_bulkload slowing down
Date: 2025-07-28 15:12:08
Message-ID: 6871c96b81c4a6c3f9029821fa48205e707dca19.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 2025-07-28 at 09:52 -0400, Ron Johnson wrote:
> That seems to imply you can only insert 4Bn rows into a table with
> attached TOAST.  Am I misunderstanding something?

Only if those rows actually contain column values big enough to
warrant storing them out of line.

And if each row had *two* such columns, you could only store
2^31 such rows.

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Stearns 2025-07-28 23:41:55 Linux VM Sizing
Previous Message Ron Johnson 2025-07-28 14:28:52 Why many more deadlocks after upgrade to PG 17.5?