have a relatively large number of points ~3.5m and want to count the number of these within administrative boundaries (182 polygons). Point data is in a PostGIS db (through a materialized view) polygons are in simple shapefile (not in db)
Initially running the points in polygon just stalled my machine so I've tried breaking down the query using a filter on the points (which gives 150,000 points to count). This still doesn't run. I've tested the shapefile with very small (30) data set and no problems there.
My workround is to save out a shapefile, but i'd like to know why it's not working and if there is an alternate tool in QGIS i can try? Ultimately I want a basic choropleth map to show how many points in each admin area (polygon) I