Re: BUG #5165: Poor performance with Left-join where right side does not exist

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: BUG #5165: Poor performance with Left-join where right side does not exist
Дата
Msg-id 603c8f070911041707k1b8fdb85m7e11795702b79c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #5165: Poor performance with Left-join where right side does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #5165: Poor performance with Left-join where right side does not exist  (assaf lehr <assaf_lehr@yahoo.com>)
Список pgsql-bugs
Дерево обсуждения 
On Wed, Nov 4, 2009 at 3:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "assaf" <assaf_lehr@yahoo.com> writes:
>> PostgreSQL version: 8.37
>> Description: =A0 =A0 =A0 =A0Poor performance with Left-join where right =
side does
>> not exist
>
> 8.4 might be smarter about this case for you. =A0It's hard to tell for su=
re
> with so few details.

EXPLAIN output would be a good place to start, and EXPLAIN ANALYZE for
the queries that run quickly enough that you can let them run to
completion.

...Robert

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5165: Poor performance with Left-join where right side does not exist
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5161: tome nota del siguiente error un error ha ocurrido 999