Re: out of memory for query result

From: Tim <ttsai(at)pobox(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: out of memory for query result
Date: 2005-04-29 18:43:00
Message-ID: 20050429184300.GA29985@sleepy.wojomedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-04-29 18:43:18 Re: ip connection on local p2p network
Previous Message Alvaro Herrera 2005-04-29 18:38:30 Re: Tuning queries inside a function