Re: Oracle v. Postgres 9.0 query performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Oracle v. Postgres 9.0 query performance
Дата
Msg-id 6665.1307672724@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Oracle v. Postgres 9.0 query performance  (Tatsuo Ishii <ishii@postgresql.org>)
Список pgsql-performance
Tatsuo Ishii <ishii@postgresql.org> writes:
> Just out of curiosity, is there any chance that this kind of query is
> speeding up in 9.1 because of following changes?

>      * Allow FULL OUTER JOIN to be implemented as a hash join, and allow
>        either side of a LEFT OUTER JOIN or RIGHT OUTER JOIN to be hashed
>        (Tom Lane)

The given query wasn't an outer join, so this wouldn't affect it.

            regards, tom lane

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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Oracle v. Postgres 9.0 query performance
Следующее
От: bakkiya
Дата:
Сообщение: Re: 100% CPU Utilization when we run queries.