Re: Out of memory error

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