Re: out of memory for query result

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: ttsai(at)pobox(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: out of memory for query result
Date: 2005-04-29 16:58:08
Message-ID: 20050429165808.GA2540@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 29, 2005 at 10:47:36AM -0500, ttsai(at)pobox(dot)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2005-04-29 16:59:14 Slowness of Big Graphical Arrays
Previous Message Shelby Cain 2005-04-29 16:54:11 Re: Increasing statistics results in worse estimates