[GENERAL] bytea columns and large values

2011-09-27 Thread David North
any setting I can change or any alternate method of reading I can use to get around this? Thanks, -- David North, Software Developer, CoreFiling Limited http://www.corefiling.com Phone: +44-1865-203192 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] bytea columns and large values

2011-09-28 Thread David North
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

Re: [GENERAL] bytea columns and large values

2011-09-29 Thread David North
n the data into smaller lumps and store one per row (it's actually a bunch of serialized Java objects, so putting them all in one field of one row was rather lazy in the first place). I'll also apply GZip to keep the amount of data in any given bytea/lob as small as possible. Dav