From: Greg Stark <gsstark@mit.edu>
To: mmurrain@dbdes.com
Cc: Thomas F.O'Connell <tfo@sitening.com>
Cc: CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
Cc: sad@bankir.ru
Cc: pgsql-sql@postgresql.org
Subject: Re: help on a query
Date: 08 Oct 2004 23:17:38 -0400
Message-ID: <87sm8o4m25.fsf@stark.xeocode.com> (raw)
In-Reply-To: <4166AFF9.1000603@murrain.net>
References: <NYe01121-06b74e7b@companiongroup.com>
<B26D13E6-193B-11D9-936A-000D93AE0944@sitening.com>
<4166AFF9.1000603@murrain.net>
Michelle Murrain <tech@murrain.net> writes:
> The OUTER JOIN version is quite a bit more efficient (by an order of magnitude)
> than the option with WHERE NOT EXISTS subquery.
This is going to be heavily dependent on the version of postgres. IN/NOT IN
execution has improved a lot in 7.4 and later. If you're still on 7.3 then the
outer join will be better. But in 7.4 I would actually expect the NOT IN or
the NOT EXISTS to be faster.
--
greg
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-sql@postgresql.org
Cc: gsstark@mit.edu, mmurrain@dbdes.com, tfo@sitening.com, CHRIS.HOOVER@companiongroup.com, sad@bankir.ru
Subject: Re: help on a query
In-Reply-To: <87sm8o4m25.fsf@stark.xeocode.com>
* 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