Re: Oracle v. Postgres 9.0 query performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Oracle v. Postgres 9.0 query performance
Date
Msg-id 6665.1307672724@sss.pgh.pa.us
Whole thread Raw
In response to Re: Oracle v. Postgres 9.0 query performance  (Tatsuo Ishii <ishii@postgresql.org>)
List 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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Oracle v. Postgres 9.0 query performance
Next
From: bakkiya
Date:
Subject: Re: 100% CPU Utilization when we run queries.