[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] out of memory for query result
From:       Tim <ttsai () pobox ! com>
Date:       2005-04-29 18:43:00
Message-ID: 20050429184300.GA29985 () sleepy ! wojomedia ! com
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]