[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