Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Fuhr
Subject Re: out of memory for query result
Date
Msg-id 20050429165808.GA2540@winnie.fuhr.org
Whole thread Raw
In response to out of memory for query result  (ttsai@pobox.com)
Responses Re: out of memory for query result  (Tim <ttsai@pobox.com>)
List pgsql-general
Tree view 
On Fri, Apr 29, 2005 at 10:47:36AM -0500, ttsai@pobox.com wrote:
>
> DBD::Pg::st execute failed: out of memory for query result

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.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Shelby Cain
Date:
Subject: Re: Increasing statistics results in worse estimates
Next
From: Chris Browne
Date:
Subject: Slowness of Big Graphical Arrays