Re: [GENERAL] "The index is not optimal" GiST warnings

James Robinson writes: > ... provokes the following warning 14 times (on PostgreSQL 9.5): > DEBUG: picksplit method for column 1 of index > "no_overlapping_rows_orig" failed > HINT: The index is not optimal. To optimize it, contact a developer, >

[GENERAL] "The index is not optimal" GiST warnings

Folks, We are using triggers and daterange-enhanced side-tables for temporal logging of inserts/updates/deletes of data so that we can perform arbitrary point-in-time reporting. Given a slightly augmented many-many relationship table like: Table