Postgres Pro
Downloads
Home   >   mailing lists

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

From Sam Mason
Subject Re: where does postgres keep the query result until it is returned?
Date
Msg-id 20100917131951.GC31536@samason.me.uk
Whole thread Raw
In response to Re: where does postgres keep the query result until it is returned?  (Sam Mason <sam@samason.me.uk>)
Responses Re: where does postgres keep the query result until it is returned?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Sam Mason
Date:
Subject: Re: where does postgres keep the query result until it is returned?
Next
From: Tom Lane
Date:
Subject: Re: What's wrong with this query?