Skip to main content
7 events
when toggle format what by license comment
Oct 11, 2022 at 11:31 vote accept MrXsquared
Nov 16, 2021 at 18:55 comment added geozelot @MrXsquared likely an index issue - your query vs mine on the data set I outlined is 3 minutes vs. 20 seconds...
Nov 16, 2021 at 11:13 comment added geozelot Note that, while query syntax increases somewhat, ST_Dumping (and potentially even ST_SubDivideing) your MultiPolygons into a fully indexed table will have a significant impact on query time. With 30 simple polygons (30 vertices each), covering roughly 30% of the points layer extent, the LATERAL query returns ~ 1.5 million hits (summed over _cnt) from ~40M points in 20 seconds.
Nov 16, 2021 at 10:50 history edited geozelot CC BY-SA 4.0
deleted 1 character in body
Nov 16, 2021 at 10:39 history edited geozelot CC BY-SA 4.0
added 374 characters in body
Nov 16, 2021 at 10:33 history edited geozelot CC BY-SA 4.0
added 374 characters in body
Nov 16, 2021 at 10:27 history answered geozelot CC BY-SA 4.0