Katherine Stoovs <ambrosiac@nedsenta.nl> writes:
> There must be something
> wrong in the planning parameters after all if a plan that is slower by
> a factor of tens or hundreds becomes estimated better than the fast
> variant.
Instead of handwaving, how about showing us EXPLAIN ANALYZE results for
both cases? You didn't even explain how the index you expect it to use
is defined...
Specifying what PG version you are using is also minimum required
information for this sort of question.
regards, tom lane