Re: where does postgres keep the query result until it is returned?

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: where does postgres keep the query result until it is returned?
Дата
Msg-id AANLkTimLmpP1SwFgiUjXJmt6vEj1jsdDURrHYbQbCkvK@mail.gmail.com
обсуждение исходный текст
Ответ на Re: where does postgres keep the query result until it is returned?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Carlos Mennens
Дата:
Сообщение: Alter Table Auto_Increment
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Alter Table Auto_Increment