Re: pg_bulkload slowing down - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: pg_bulkload slowing down
Date
Msg-id 6871c96b81c4a6c3f9029821fa48205e707dca19.camel@cybertec.at
Whole thread Raw
In response to Re: pg_bulkload slowing down  (Ron Johnson <ronljohnsonjr@gmail.com>)
List 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



pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Why many more deadlocks after upgrade to PG 17.5?
Next
From: Sam Stearns
Date:
Subject: Linux VM Sizing