Re: postgres/postgis eats memory

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