Re: Indexes works only on miss
От
Tom Lane
Тема
Re: Indexes works only on miss
Дата
Msg-id
23888.1136568386@sss.pgh.pa.us
Ответ на
Indexes works only on miss (Sebastjan Trepca)
Список
Дерево обсуждения
Indexes works only on miss Sebastjan Trepca <trepca@gmail.com>
Re: Indexes works only on miss Michael Fuhr <mike@fuhr.org>
Re: Indexes works only on miss Sebastjan Trepca <trepca@gmail.com>
Re: Indexes works only on miss "Jim C. Nasby" <jnasby@pervasive.com>
Re: Indexes works only on miss Tom Lane <tgl@sss.pgh.pa.us>
Sebastjan Trepca 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
В списке pgsql-general по дате отправления
