[postgis-tickets] [PostGIS] #2256: ST_EstimatedExtent bound to index

[PostGIS]

#2256: ST_EstimatedExtent bound to index
--------------------------+---------------------------
  Reporter:  pramsey      |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 2.5.0
 Component:  postgis      |    Version:  2.0.x
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by pramsey):

 In [changeset:"16149" 16149]:
 {{{
 #!CommitTicketReference repository="" revision="16149"
 Proof of content for reading table extent from
 the top of the index. Can be called with
 _postgis_index_extent(tbl regclass, col text)
 and returns box2d.

 Currently not added to the st_estimatedextent()
 code, because it has issues with indexes that
 have EMPTY added to them. This is a symptom
 of #2487. While it seems impossible to every
 allow index-assisted searches for EMPTY
 geometry, it will be necessary to create
 invalid keys for them (NaN, NaN, NaN, Nan)
 and then handle those keys so they don't
 pollute the index with strange bounds.

 References #2256
 }}}

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