Re: Understanding sequential versus index scans.

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Understanding sequential versus index scans.
Дата
Msg-id 407d949e0907200713y6e0a081an3c3908ec1ac0e362@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Understanding sequential versus index scans.  (Robert James <srobertjames@gmail.com>)
Список pgsql-general
On Mon, Jul 20, 2009 at 2:22 PM, Robert James<srobertjames@gmail.com> wrote:
> BTW, this is interesting, because there are only about 5 or 6 rows max
> returned from both queries - but I guess the planner expects more and hence
> changes the plan to remove duplicates.


If you sent the plans for the various attempts we might be able to
explain what's going on.

--
greg
http://mit.edu/~gsstark/resume.pdf

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

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: Documentation Improvement suggestions
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Understanding INNER JOIN versus IN subquery