Re: BUG #17089: "ERROR: invalid memory alloc request size ..." occurs when updating a fixed number of records

On Wed, 7 Jul 2021 at 21:22, PG Bug reporting form
<noreply@postgresql.org> wrote:
> After importing a CSV file that exceeds 150GB in total into the table,
> "ERROR: invalid memory alloc request size 1677721600" always occurs in the
> UPDATE of 77658539 records.

You'd get a message like that if a varlena field was to exceed
MaxAllocSize (1GB).

Here's a simple example:

create table a (a text);
insert into a values(repeat('a',600*1024*1024));
update a set a = a || a;
ERROR:  invalid memory alloc request size 1258291204

You can confirm if that's the case for you if you can narrow it down
to a single record causing the issue then check if the update would
cause a column in the table to exceed 1GB.

David