[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