[postgis-users] Is my query planner failing me, or vice versa?
Jessica M Salmon
jmsalmon at fs.fed.us
Tue Dec 13 16:08:07 PST 2005
Strk -
BINGO! Removing the Distance filter yields query times consistent with the
planner's estimates. Okay, so do I have to live with either the too-loose
&& test or the too-time-consuming Distance() <= 5000 filter? NO! I shall
try testing the distances of the perimeters of the multipolygons, as the
perimeters will have far fewer points than the shapes themselves :)
Thanks,
Meghan
More information about the postgis-users
mailing list