Re: Seq scan on join, not on subselect? analyze this

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Seq scan on join, not on subselect? analyze this
Дата
Msg-id 4529.1225651101@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Seq scan on join, not on subselect? analyze this  (Bryce Nesbitt <bryce2@obviously.com>)
Ответы Re: Seq scan on join, not on subselect? analyze this
Список pgsql-sql
Bryce Nesbitt <bryce2@obviously.com> writes:
> I'm a bit confused why the query planner is not restricting my join, and
> not using the index.  Two explain analyze statements follow.

Why are the rowcount estimates so far off?  Maybe you need to increase
the statistics target for this table.
        regards, tom lane


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

Предыдущее
От: Bryce Nesbitt
Дата:
Сообщение: Seq scan on join, not on subselect? analyze this
Следующее
От: Bryce Nesbitt
Дата:
Сообщение: Re: Seq scan on join, not on subselect? analyze this