[GENERAL] Out of memory error

2009-07-06 Thread Paul Smith
e OS cannot fully take advantage of the available RAM for processes like PostgreSQL but we aren't able to take the server down currently to re-install a 64-bit OS. -- Paul Smith http://www.pauladamsmith.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Out of memory error

2009-07-06 Thread Paul Smith
tGIS function names are still recognize without the leading "ST_"). http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2574404 # select postgis_version(); postgis_version --- 1.3 USE_GEOS=1 USE_PROJ=1

Re: [GENERAL] Out of memory error

2009-07-06 Thread Paul Smith
On Mon, Jul 6, 2009 at 7:26 PM, Paul Ramsey wrote: > If you are on PostGIS < 1.3.4 there are substantial memory leaks in > intersects() for point/polygon cases. Upgrading to 1.3.6 is > recommended. Thank you, that fixed it. -- Paul Smith http://www.pauladamsmith.com/ -- Sent via p