Hi all,
I'm using an open-source "extension" that creates an index for special type of search and you need to use a custom operator to run queries. Anyway If I run an according query with multiple filters as example also range of primary key PostgreSQL almost always selects this 3rd party index as the first index to scan. However this index is almost always slower than a "normal" index. This leads to queries with a filter primary_key < 10 taking several seconds because the 3rd party index taking that much time. In the explain plan it is visible that PostgreSQL seems to prefer this index over other indexes.
Is there any way to increase the cost for this specific index (or operator) so that any other index is always used first?
Beat Regards,
Thomas