Sebastjan Trepca <trepca@xxxxxxxxx> 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
