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

[Bruce Rindahl]

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>