[postgis-devel] 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.

Sandro Santilli strk at kbt.io
Fri Feb 4 02:53:36 PST 2022


Have you ever seen the message in the subject? I'm getting many of
these messages while loading a topology:

    DEBUG:  picksplit method for column 1 of index "edge_gist" failed
    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.

The index is:

    "edge_gist" gist (geom)

--strk;


More information about the postgis-devel mailing list