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

[PostGIS]

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

Comment (by komzpa):

 Hello,

 gist geometry index "compresses" geometry into its bounding box. It is
 impossible to get back a valid representation, even for points, as SRID is
 lost on this conversion. Only way is to go back to the heap and read it
 from there.

 Is there some clever hack around this, or you haven't checked query
 output?

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