Re: [postgis-users] Finding all 'adjacent' points in a point set

2021-07-30 Thread Paul Ramsey
> On Jul 30, 2021, at 10:44 AM, Martin Davis wrote: > > Good to know! Thanks for fessing up... ;) > > On Fri, Jul 30, 2021 at 10:27 AM Bruce Rindahl > wrote: > My mistake. The CTE and inner join methods show no measurable difference in > performance. I added a spatial index to get the

Re: [postgis-users] Finding all 'adjacent' points in a point set

2021-07-30 Thread Martin Davis
Good to know! Thanks for fessing up... ;) On Fri, Jul 30, 2021 at 10:27 AM Bruce Rindahl wrote: > My mistake. The CTE and inner join methods show no measurable difference > in performance. I added a spatial index to get the big performance > difference (Doh!) >

Re: [postgis-users] Finding all 'adjacent' points in a point set

2021-07-30 Thread Bruce Rindahl
My mistake. The CTE and inner join methods show no measurable difference in performance. I added a spatial index to get the big performance difference (Doh!) ___ postgis-users mailing list postgis-users@lists.osgeo.org