Willy-Bas Loos <willybas@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
