Search Postgresql Archives

Re: Out of memory error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux