[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