[postgis-tickets] [PostGIS] #3753: Gist penalty misbehaves if points are inserted in gridded ordered fashion
PostGIS
trac at osgeo.org
Wed May 10 09:05:05 PDT 2017
#3753: Gist penalty misbehaves if points are inserted in gridded ordered fashion
---------------------+---------------------------
Reporter: komzpa | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.3.3
Component: postgis | Version: 2.3.x
Keywords: |
---------------------+---------------------------
If data can be perceived as strips, gist penalty will always be zero,
since leaves will be (width x height) = 0 x H = 0. For 2D data in ND index
it will always be 0.
There is patch by x4m for cubes that solves this problem by returning
expansion of lesser dimension (length instead of volume etc.) with special
mark:
https://github.com/x4m/postgres_g/commit/76972490adb756e02df07f28723951f269729fcc
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3753>
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