BUG #4804: ERROR out of memory on select bytea field legth about 120Mb
The following bug has been logged online:
Bug reference: 4804
Logged by: Vadim Fedorenko
Email address: junk@fromru.com
PostgreSQL version: 8.3.3
Operating system: Windows 2003 Server R2 64bit
Description: ERROR out of memory on select bytea field legth about
120Mb
Details:
Hi!
I have a database about 4Gb and pg_dump fails with
ERROR: out of memory
DETAIL: Failed on request of size 536870912.
on it.
I found out that it fails on selecting bug bytea field:
select length(binarydata) from config where datasize >120000000
results 138124811
and
select binarydata from config where datasize >120000000
results
ERROR: out of memory
DETAIL: Failed on request of size 536870912.
how can I workaround this?
"Vadim Fedorenko" <junk@fromru.com> writes:
I have a database about 4Gb and pg_dump fails with
ERROR: out of memory
DETAIL: Failed on request of size 536870912.
I found out that it fails on selecting bug bytea field:
Huh, how did you get that value into the table in the first place?
how can I workaround this?
Increase the memory limit the postmaster runs under. If it's
a 32-bit machine, you might need to decrease shared_buffers
so there's more address space available as workspace.
regards, tom lane