[postgis-tickets] [PostGIS] #4797: Slow down on ST_DWithin upgrading from PostGis 2.5 to PostGis 3.0

[PostGIS]

#4797: Slow down on ST_DWithin upgrading from PostGis 2.5 to PostGis 3.0
----------------------+---------------------------
  Reporter:  aelg     |      Owner:  pramsey
      Type:  defect   |     Status:  closed
  Priority:  medium   |  Milestone:  PostGIS 3.1.0
 Component:  postgis  |    Version:  3.0.x
Resolution:  wontfix  |   Keywords:
----------------------+---------------------------
Changes (by pramsey):

 * status:  new => closed
 * resolution:   => wontfix


Comment:

 The plans are almost exactly the same, and the performance drop happens in
 the nested loop left join, which doesn't even have a spatial clause. This
 points to some other, different, issue to me. If you can provide test
 data, and a query that demonstrates the difference, I can look at it, but
 otherwise there's nothing I can do.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4797#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.