> Rows are sent back in the entireity, so the PG instance would need > enough memory to work with that row. When you're running a 32bit > version of PG, values whose size is beyond ~100MB are a bit touch and go > whether it will work. ?? I hear that it's posible to store up to a GiB as a value for a "text" field. How would i possibly retrieve that data from the database? It would be logical to use work_mem for this.. (IMHO) Cheers, Willy-Bas -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general