Hey, in theory st_intersection already uses index and st_intersects under
the hood,
I personally prefer to explicitly add it, as I found it more easy to
understand.
What you didn't take into account is that you may get multiline,
for instance if your polygon is a U, and the line cross it left to
So there is a total of over 560,000 points in the 8000 records returned. I
would have assumed that it was simply returning the contents of the geometry
column and that the number of points (albeit they take up space) would not
affect the select time. Is PostGIS doing something with the