[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.

-------------- 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