[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