[postgis-tickets] [PostGIS] #3344: Unnecessary use of table/possible speed improvement

[PostGIS]

#3344: Unnecessary use of table/possible speed improvement
--------------------------+---------------------------
  Reporter:  postgispaul  |      Owner:  pramsey
      Type:  enhancement  |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS 2.1.9
 Component:  postgis      |    Version:  2.1.x
Resolution:  wontfix      |   Keywords:
--------------------------+---------------------------

Comment (by robe):

 Paul,
 Nope there isn't currently anyway to tell postgres planner that info. Do
 you have an index at all on the names table.  I would have expected at
 least an index scan thought that would depend on size of table.

 We'll look at #3341 one in a bit.  That one requires more reading to see
 if there is an issue or not or just a side-effect of 1) cartesian long/lat
 data not being a good choice for doing differencing (particularly for
 large areas), its better to transform and then transform back, 2) just the
 nature of double-precision rounding

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