[postgis-users] Improvement suggestion

Paul van der Linden paul.doskabouter at gmail.com
Mon Dec 3 09:41:25 PST 2018


I indeed know that trick to eliminate an st_intersection, but that comes at
the cost of a st_within.
In the test-case I'm examing now, the st_intersects and st_within both take
about 40 seconds and the st_intersection takes about a minute.
So to eliminate one of the 40 seconds (and in this case even the
intersection because st_within is true), a function returning the relation
could speed up things
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181203/dd892624/attachment.html>


More information about the postgis-users mailing list