[GENERAL] Out of memory error
.id AND location_id=loc.id) AND intersects(loc.location, ni.location) AND ni.pub_date > '2009-6-25' AND ni.pub_date < '2009-7-3'; We're aware that the 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
On Mon, Jul 6, 2009 at 3:34 PM, Tom Lane wrote: > Clearly a memory leak, but it's not so clear exactly what's causing it. > What's that intersects() function? Can you put together a > self-contained test case? It's actually ST_Intersects from PostGIS (some of the PostGIS 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 USE_STATS=1 -Paul -- 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
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 pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
