[postgis-tickets] [PostGIS] #3932: Enable Index Only Scan on geometry

PostGIS trac at osgeo.org
Tue Nov 21 22:59:05 PST 2017


#3932: Enable Index Only Scan on geometry
----------------------+---------------------------
  Reporter:  x4m      |      Owner:  pramsey
      Type:  defect   |     Status:  closed
  Priority:  medium   |  Milestone:  PostGIS 2.4.2
 Component:  postgis  |    Version:  2.4.x
Resolution:  invalid  |   Keywords:
----------------------+---------------------------

Comment (by x4m):

 Certainly, clever hacks are possible, I can produce new opclass for IoS
 which is not doing irreversible compression. And it will be IoS-able. But
 I'm not sure it worth it, in my benchmarks for cube IoS vs Index Scan was
 like 90 seconds to 100 seconds.

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


More information about the postgis-tickets mailing list