Re: [GENERAL] bytea columns and large values

2011-09-29 Thread David North
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. David -- David North, Software

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

[GENERAL] bytea columns and large values

2011-09-27 Thread David North
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 your subscription