From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tatsuo Ishii <ishii@postgresql.org>
Cc: sfrost@snowman.net
Cc: tcapobianco@prospectiv.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Oracle v. Postgres 9.0 query performance
Date: Thu, 09 Jun 2011 22:25:24 -0400
Message-ID: <6665.1307672724@sss.pgh.pa.us> (raw)
In-Reply-To: <20110610.112143.168304625710382767.t-ishii@sraoss.co.jp>
References: <10260.1307547185@sss.pgh.pa.us>
<1307547634.1990.26.camel@tony1.localdomain>
<20110608155159.GA18128@tamriel.snowman.net>
<20110610.112143.168304625710382767.t-ishii@sraoss.co.jp>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, ishii@postgresql.org, sfrost@snowman.net, tcapobianco@prospectiv.com
Subject: Re: Oracle v. Postgres 9.0 query performance
In-Reply-To: <6665.1307672724@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox