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

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: where does postgres keep the query result until it is returned?
Дата
Msg-id 20100917131951.GC31536@samason.me.uk
обсуждение исходный текст
Ответ на Re: where does postgres keep the query result until it is returned?  (Sam Mason <sam@samason.me.uk>)
Ответы Re: where does postgres keep the query result until it is returned?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
On Fri, Sep 17, 2010 at 02:14:57PM +0100, Sam Mason wrote:
> Postgres, the server software, will spill large results (and any
> intermediate working sets) to disk automatically as needed.  I believe
> any memory allocated for this task will be up to work_mem in size.

That wasn't very clear was it; when I said "this task" I meant the task
of accumulating results before things spill.

--
  Sam  http://samason.me.uk/

В списке pgsql-general по дате отправления:

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: where does postgres keep the query result until it is returned?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What's wrong with this query?