Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB
Date
Msg-id 1623899.1737043379@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Hello, I need your help. The essence of the problem is that I am trying to
> download a bytea field from a table row. The size of the data in the field
> is about 700 MB. In response, I receive an out-of-memory error.

I don't see this as a Postgres bug.  If you want to work with values
that large, you'd better have plenty of memory available.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4
Next
From: Ilya Knyazev
Date:
Subject: Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB