Ted Allen <tallen@xxxxxxxxxxxxxxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
