Re: postgres/postgis eats memory

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Martin Guether <martin(dot)guether(at)campus(dot)tu-berlin(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres/postgis eats memory
Date: 2011-10-21 23:45:11
Message-ID: 4EA20407.1050606@ringerc.id.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-10-21 23:48:04 Re: force JDBC driver fetch / autocommit parameters?
Previous Message Eric Smith 2011-10-21 22:45:02 adding a column takes FOREVER!