Skip site navigation (1) Skip section navigation (2)

BUG #6620: Out of memory error

From: sathish(at)myc2s(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6620: Out of memory error
Date: 2012-04-27 14:06:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6620
Logged by:          sathish
Email address:      sathish(at)myc2s(dot)com
PostgreSQL version: 9.1.3
Operating system:   windows Xp 32 bit

i have a Postgis table with about 2 million polyline records.  The most
number of points I have in the geometry field is about 500.  I have a
java program that does a select for most of these records
and do some processing with them before writing them to a file.
Unfortunately, I seem to keep getting this error:

 execute failed: out of memory for query result

This query works fine with less select statement,
my next largest table.  I believe the program is failing at the first
execute after prepare on this table.

pgsql-bugs by date

Next:From: Simon RiggsDate: 2012-04-27 14:16:04
Subject: Re: BUG #6619: Misleading output from slave when host is not running
Previous:From: Ryan KellyDate: 2012-04-27 11:22:35
Subject: Re: hstore parser incorrectly handles malformed input

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group