[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 postgispaul):

 Sorry for omitting the versions, they are:
 POSTGIS="2.1.7 r13414" GEOS="3.5.0-CAPI-1.9.0 r4090" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24 GDAL_DATA not found"
 LIBXML="2.7.8" LIBJSON="UNKNOWN" TOPOLOGY RASTER

 PostgreSQL 9.4.1, compiled by Visual C++ build 1800, 64-bit

 And as you say, it's more a Postgres issue: I agree, but wasn't sure about
 it.
 As for your last remark: names.id isn't a primary key, but I can't see why
 that should make a difference in the end-result.

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