The following bug has been logged online:

Bug reference:      4804
Logged by:          Vadim Fedorenko
Email address:      j...@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?

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to