[PostGIS] #5992: DEBUG: picksplit method for column 1 of index "edge_gist" failed

[PostGIS]

#5992: DEBUG: picksplit method for column 1 of index "edge_gist" failed
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.6.1
Component:  postgis  |    Version:  3.5.x
 Keywords:           |
---------------------+---------------------------
 I receive this message during TopoGeom_AddLinestring operation when adding
 a set of edges to a topology which started as a single-edge topology (so
 all queries are happening within a transaction):

 > DEBUG: picksplit method for column 1 of index "edge_gist" failed

 The existing edge has a bbox which fully covers the line being added,
 during operations the existing edge is being updated due to splitting, and
 new edges are being created, a lot of them (see #5990 for the test SQL
 file to reproduce). You get a flood of these debug messages during
 operations.

 It could be harmless but the HINT that follows suggests we might be doing
 something about it:

 > HINT:  The index is not optimal. To optimize it, contact a developer, or
 try to use the column as the second one in the CREATE INDEX command.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5992>
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.