From: Josh Berkus <josh@agliodbs.com>
To: sqllist <pgsql-sql@postgresql.org>
Subject: Re: Outer Joins
Date: Thu, 02 Nov 2000 08:55:36 -0800
Message-ID: <3A019C88.942D17B8@agliodbs.com> (raw)
References: <sa013083.025@eskom.co.za>
<3A01984C.7FFE3B90@agliodbs.com>
Marc, Tom,
> Good point. Frankly, if you have a relevant large population of data
> (>10,000 rows) to test, I'd love to see comparative execution tests
> between the two query structures.
>
> Fortunately, this will all soon become moot; Tom says that outer joins
> have been stable in the 7.1 build for a while. Speaking of which,
> when's the 7.1 "release"? Huh, huh?
On second thought, couldn't we use some kind of EXCLUDES clause to
expedite this? Tom?
Further, it occurs to me that as in my query, you don't want to use "NOT
IN" on *either* version. Instead, use "NOT EXISTS", which is much, much
faster.
-Josh Berkus
--
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 436-9166
for law firms, small businesses fax 436-0137
and non-profit organizations. pager 338-4078
San Francisco
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: josh@agliodbs.com
Subject: Re: Outer Joins
In-Reply-To: <3A019C88.942D17B8@agliodbs.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