[postgis-tickets] [PostGIS] #2861: PostGis Topology performance improvements : index on containing_face

[PostGIS]

#2861: PostGis Topology performance improvements : index on containing_face
--------------------------+-------------------
  Reporter:  remic        |      Owner:  strk
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:
 Component:  topology     |    Version:  2.1.x
Resolution:               |   Keywords:
--------------------------+-------------------

Comment (by strk):

 I just stumbled upon the usage in _ST_AddFaceSplit function as I move
 toward having it rewritten in C. This comment is just to confirm that an
 index on containing_face would be used. It'll be interesting to determine
 if the probable high frequency of NULL values there would recommend making
 a partial index rather than a full index (ie: WHERE containing_face IS NOT
 NULL).

 Of course numbers would still be interesting to read here :)

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