Re: Oracle v. Postgres 9.0 query performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: sfrost(at)snowman(dot)net, tcapobianco(at)prospectiv(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Oracle v. Postgres 9.0 query performance
Date: 2011-06-10 02:25:24
Message-ID: 6665.1307672724@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tatsuo Ishii <ishii(at)postgresql(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message bakkiya 2011-06-10 07:39:17 Re: 100% CPU Utilization when we run queries.
Previous Message Tatsuo Ishii 2011-06-10 02:21:43 Re: Oracle v. Postgres 9.0 query performance