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

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

- why?
- how about 64 bit?
- should this be documented?



--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Alter Table Auto_Increment
Next
From: Thom Brown
Date:
Subject: Re: Alter Table Auto_Increment