New answers tagged spatial-index
The answer is right in your explain results. When you put the index on the polygons, the planner thinks: "aha, I can do a nested loop on the points and quickly get each polygon that is of interest for the points". This ends up being wrong, probably because you (a) have more points than polygons and (b) evaluating the index condition is only the cheapest ...
Top 50 recent answers are included