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

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: where does postgres keep the query result until it is returned?
Date: 2010-09-17 13:19:51
Message-ID: 20100917131951.GC31536@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-09-17 14:05:16 Re: What's wrong with this query?
Previous Message Sam Mason 2010-09-17 13:14:57 Re: where does postgres keep the query result until it is returned?