Willy-Bas Loos <willy...@gmail.com> writes: >> 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? That's the *theoretical* limit. In a 32-bit build, the practical limit is going to be quite a bit less. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general