Re: where does postgres keep the query result until it is returned? - Mailing list pgsql-general

From Tom Lane
Subject Re: where does postgres keep the query result until it is returned?
Date
Msg-id 9063.1284990466@sss.pgh.pa.us
Whole thread Raw
In response to Re: where does postgres keep the query result until it is returned?  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: where does postgres keep the query result until it is returned?  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_relation_size / could not open relation with OID #
Next
From: Ian Barwick
Date:
Subject: A note on pg_upgrade and missing "pg_upgrade_support.so"