Willy-Bas Loos <willybas@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