Hello people,
I'm having trouble to persuade index scan to check all of the conditions
I specify _inside_ index cond. That is, _some_ condition always get
pushed out of index cond and applied later (which will often result, for
my real table contents, in too many unwanted rows initially hit
15.10.2010 22:29, Tom Lane:
Nikolai Zhubrn-a-zh...@yandex.ru writes:
So, in (1, 2) condition is not in Index Cond anymore! Why is that? How
can I push it back?
It thinks the indexscan condition is sufficiently selective already.
An = ANY condition like that will force multiple index