On Wed, Sep 28, 2011 at 3:28 AM, David North <d...@corefiling.co.uk> wrote: > On 28/09/11 01:50, Craig Ringer wrote: >> >> On 09/28/2011 01:01 AM, David North wrote: >> >>> testdb=# select * from problem_table; >>> ERROR: invalid memory alloc request size 2003676411 >> >> What Pg version are you using? >> >> On which platform? >> >> 32-bit or 64-bit OS? If 64-bit, with a 32-bit or 64-bit build of >> PostgreSQL? > > psql (PostgreSQL) 9.0.4 > > 64 bit fedora: > > Fedora release 14 (Laughlin) > Linux mybox 2.6.35.14-95.fc14.x86_64 #1 SMP Tue Aug 16 21:01:58 UTC 2011 > x86_64 x86_64 x86_64 GNU/Linux > > I presume my build of PostgreSQL is x64 - ldd `which psql` spits out lots of > references to lib64.
sending ~1GB bytea values is borderline crazy, and is completely crazy if you are not absolutely sure the transmission is not 100% binary. I don't know if the JDBC sends/receives bytea as binary, but it may not. If not, you might have better luck with the large object interface. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
