Willy-Bas Loos <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general