[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.

[Darafei "Komяpa" Praliaskouski]

Hi,

What branch is it on? I touched picksplit on master but it passed the tests
fine.

This normally can happen if you're pushing dozens of same values into
index. I'd also expect it on EMPTY's. May happen if you're having a lot of
updates on one row without vacuum collecting stuff.

I do not usually have DEBUG enabled.


пт, 4 лют 2022, 13:53 карыстальнік Sandro Santilli <strk at kbt.io> напісаў:

> 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;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20220204/852421ed/attachment.html>