Re: Indexes works only on miss

Sebastjan Trepca <trepca@gmail.com> writes:
> "Seq Scan on test  (cost=0.00..119.11 rows=263 width=11)"
> "  Filter: (("Owner")::text = 'root'::text)"

> "Index Scan using idx_test_owner on test  (cost=0.00..96.56 rows=28
> width=11)"
> "  Index Cond: (("Owner")::text = 'blah'::text)"

> Why is this happening?

This is the planner doing what it is supposed to do, ie, decide whether
the index is selective enough to be worth using.

            regards, tom lane