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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: knuazev(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18775: PQgetCopyData always has an out-of-memory error if the table field stores bytea ~700 MB
Date: 2025-01-16 16:02:59
Message-ID: 1623899.1737043379@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

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