Re: postgres/postgis eats memory - Mailing list pgsql-general

From Craig Ringer
Subject Re: postgres/postgis eats memory
Date
Msg-id 4EA20407.1050606@ringerc.id.au
Whole thread Raw
In response to postgres/postgis eats memory  (Martin Guether <martin.guether@campus.tu-berlin.de>)
List pgsql-general
On 10/21/2011 09:05 PM, Martin Guether wrote:
> Hi guys,
> on a test maschine from my university i'm running into a weird problem.
>
> the issue (i attached detail info):
>
> The running query eats more and more memory.(seen in htop) It'll start
> using virtual memory and after eating up that one, too, postgres will
> crash with:
>
> psql:/home/mguether/sql/benchmark.sql:6: NOTICE:  std::bad_alloc
> psql:/home/mguether/sql/benchmark.sql:6: ERROR:  GEOS intersects()
> threw an error!

That's an allocation within PostGIS (as it's C++) failing.

Given that the issues you're having are mainly with PostGIS I'd
recommend asking on the PostGIS mailing lists for help.

--
Craig Ringer

pgsql-general by date:

Previous
From: Eric Smith
Date:
Subject: adding a column takes FOREVER!
Next
From: Craig Ringer
Date:
Subject: Re: force JDBC driver fetch / autocommit parameters?