[postgis-tickets] [PostGIS] #3548: Slow queries with ST_DWithin and geography columns

[PostGIS]

#3548: Slow queries with ST_DWithin and geography columns
--------------------------+----------------------------------
  Reporter:  rdallasgray  |      Owner:  pramsey
      Type:  defect       |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS 2.2.3
 Component:  postgis      |    Version:  2.1.x
Resolution:  invalid      |   Keywords:  ST_DWithin geography
--------------------------+----------------------------------

Comment (by rdallasgray):

 OK, thanks, that makes sense.

 How about the issue that the order in which the conditions are declared
 affects the performance? Should the query planner not be able to take into
 account that geometry is going to be considerably faster than geography
 and optimise accordingly?

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3548#comment:3>
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.