Re: index not being used. Why?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: index not being used. Why?
Дата
Msg-id 20070309160211.GA24502@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на index not being used. Why?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Список pgsql-sql
On Fri, Mar 09, 2007 at 12:01:30PM -0300, Gerardo Herzig wrote:
> Hi all. I have this 2 relations

How big are they?

>   ->  Hash  (cost=9.08..9.08 rows=408 width=55)
>         ->  Seq Scan on pages  (cost=0.00..9.08 rows=408 width=55)

The planner thinks it will get 408 rows.  How big a percentage of the
table is that?  

Also, what does EXPLAIN ANALYSE say about this?

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
If they don't do anything, we don't need their acronym.    --Josh Hamilton, on the US FEMA


В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: index not being used. Why?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: index not being used. Why?