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: | Raw Message | Whole Thread | 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
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! |