Re: Out of memory error - Mailing list pgsql-general

From Mark Cave-Ayland
Subject Re: Out of memory error
Date
Msg-id 4A530E68.3070701@siriusit.co.uk
Whole thread Raw
In response to Re: Out of memory error  (Paul Smith <paulsmith@pobox.com>)
List pgsql-general
Paul Smith wrote:

> It's actually ST_Intersects from PostGIS (some of the PostGIS function
> names are still recognize without the leading "ST_").

Not for too much longer - these have been deprecated for a while ;)

> http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2574404
>
> # select postgis_version();
>             postgis_version
> ---------------------------------------
>  1.3 USE_GEOS=USE_PROJ=1 USE_STATS=1

Can you do a "SELECT postgis_full_version()"? If you're running anything
less than 1.3.6, then the first thing you must do is upgrade. 1.3.6 has
several important memory-leak fixes IIRC.


HTH,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Feistel cipher, shorter string and hex to int
Next
From: "Albe Laurenz"
Date:
Subject: Re: Efficiently move data from one table to another, with FK constraints?