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

Bruce Rindahl bruce.rindahl at gmail.com
Mon Aug 2 09:03:15 PDT 2021


Quick follow up.  Inner join vs CTE on one machine with both PG11 and PG13
installed the results are:

Ver      Inner Join       CTE
PG11      1.5 sec        10 min
PG13      1.2 sec        1.4 sec

Whoever did that work on the planner to inline CTE's as subqueries, Thank
you!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210802/848c1a02/attachment.html>


More information about the postgis-users mailing list