'Re: [postgis-users] ST_DWithin question'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] ST_DWithin question
From:       "Arnaud L." <arnaud.listes () codata ! eu>
Date:       2021-10-22 14:04:25
Message-ID: 3c533c1f-d5c9-d43c-73d2-446bc8df72bd () codata ! eu
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

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
[Attachment #5 (text/html)]

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    Le 22/10/2021 Ă  16:01, Marco Boeringa a ĂŠcrit  :<br>
    <blockquote type="cite"
      cite="mid:a5345f47-f63e-8264-8a16-1bba9e0528dc@boeringa.demon.nl">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      I have now done some preliminary testing with a &gt; 10M records
      dataset, but my first impression is that 'ST_Intersects' is not
      faster than 'ST_DWithin' with range 0. <br>
      <p>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.<br>
      </p>
    </blockquote>
    <br>
    Thanks for the feedback Marco.<br>
    Quite surprising to me (but I know nothing about Postgis'
    internals), but good to know.<br>
    <br>
    Regards<br>
    --<br>
    Arnaud<br>
    <div id="grammalecte_menu_main_button_shadow_host" style="width:
      0px; height: 0px;"></div>
  </body>
</html>

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 