[postgis-users] ST_DWithin question
Arnaud L.
arnaud.listes at codata.eu
Fri Oct 22 07:04:25 PDT 2021
Le 22/10/2021 à 16:01, Marco Boeringa a écrit :
> I have now done some preliminary testing with a > 10M records dataset,
> but my first impression is that 'ST_Intersects' is not faster than
> 'ST_DWithin' with range 0.
>
> In fact, I have the feeling it may be about 20-25% slower (e.g. 2m48s
> versus for 'ST_Intersects' versus 2m07s for 'ST_DWithin' was one
> result). At least, that is what I am currently seeing when I replace
> the 'ST_Intersects' call with 'ST_DWithin' in your optimized query,
> and this difference seems quite consistent when I re-run this multiple
> times.
>
Thanks for the feedback Marco.
Quite surprising to me (but I know nothing about Postgis' internals),
but good to know.
Regards
--
Arnaud
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211022/54ff5b25/attachment.html>
More information about the postgis-users
mailing list