Re: out of memory for query result - Mailing list pgsql-general

From Tim
Subject Re: out of memory for query result
Date
Msg-id 20050429184300.GA29985@sleepy.wojomedia.com
Whole thread Raw
In response to Re: out of memory for query result  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Fri, Apr 29, 2005 at 10:58:08AM -0600, Michael Fuhr wrote:
> Have you considered using a cursor to fetch the query results?  That
> should prevent the API from trying to load the entire result set
> into memory.

  I can do that.  I didn't know the API would try to load the entire
result set into memory first though.  yikes!

  Tim

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Tuning queries inside a function
Next
From: Tony Caduto
Date:
Subject: Re: ip connection on local p2p network