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
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
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