Ted Allen <[email protected]> writes:
> 600mb measured by get_octet_length on data. If there is a better way to
> measure the row/cell size, please let me know because we thought it was the
> >1Gb problem too. We thought we were being conservative by getting rid of
> the larger rows but I guess we need to get rid of even more.
Yeah, the average expansion of bytea data in COPY format is about 3X :-(
So you need to get the max row length down to around 300mb. I'm curious
how you got the data in to start with --- were the values assembled on
the server side?
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
