[postgis-tickets] [PostGIS] #5032: _postgis_index_extent gives bogus results on combined gist indexes

PostGIS trac at osgeo.org
Wed Aug 17 09:41:12 PDT 2022


#5032: _postgis_index_extent gives bogus results on combined gist indexes
-----------------------------+---------------------------
  Reporter:  Björn Harrtell  |      Owner:  pramsey
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.3.0
 Component:  postgis         |    Version:  master
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Comment (by pramsey):

 Firstly, index extents are still estimated, since an index with a lot of
 deletions can be quite over-determined relative to the actual data extent.

 Secondly, the answer to the bug is either getting very clever about
 finding the geometry part of the index or just noticing it's a multi-key
 index and skipping the index check in that case. Given the rarity of the
 multi-key case, I think I opt for the latter.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5032#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.


More information about the postgis-tickets mailing list