I am running an area intersection query on two large multipolygon tables (a few million rows).
SELECT r.geomFROM public.my_table rWHERE EXISTS ( SELECT gid FROM public.my_table_intersection WHERE r.class = '2' AND st_intersects(r.geom, geom) AND ST_IsValid(r.geom) AND ST_IsValid(geom) AND (st_area(st_intersection(r.geom, geom))/st_area(r.geom)) > 0.1);The code appears to work with small test files but I have left it for ages with my main files with no result yet. I know that such processing on very large datasets can be very slow, is this sort of operation within PostGis's capabilities or am I pushing it too far? Is there perhaps an alternative way of doing such processing on very large data-sets? would ArcGIS be quicker? Thanks for your time
أكثر...
SELECT r.geomFROM public.my_table rWHERE EXISTS ( SELECT gid FROM public.my_table_intersection WHERE r.class = '2' AND st_intersects(r.geom, geom) AND ST_IsValid(r.geom) AND ST_IsValid(geom) AND (st_area(st_intersection(r.geom, geom))/st_area(r.geom)) > 0.1);The code appears to work with small test files but I have left it for ages with my main files with no result yet. I know that such processing on very large datasets can be very slow, is this sort of operation within PostGis's capabilities or am I pushing it too far? Is there perhaps an alternative way of doing such processing on very large data-sets? would ArcGIS be quicker? Thanks for your time
أكثر...