Birgit Laggner wrote:
Hallo,
I have 2 large datasets (the first one consists of polygons and has
15099748 rows and the second is a point geometry with 76421902 rows) and
would like to sort out which points are located within which polygons.
The aim is to calculate some statistics (count, min, max, avg) for the
points in every polygon. When I tested the query with a small subset,
everything worked fine and the result looked the way I expected. But
applied on the whole datasets, the query runs for approximately 10 mins
and then stops because the server is out of memory.
Hi Birgit,
If PostgreSQL stops due to lack of memory, it generally dumps
information about memory usage into the server log file before it
terminates. Can you see any such information in your PostgreSQL log
file? If so, posting it here would help greatly, along with the output
of "SELECT postgis_full_version()".
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
