From: Patrick Vedrines <patrick.vedrines@adpcl.com>
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Left Outer Join much faster than non-outer Join?
Date: Thu, 31 Mar 2005 10:28:11 +0200
Message-ID: <008001c535cb$939f48d0$1e0baf96@pcpatrickxp> (raw)
References: <Pine.LNX.4.58.0503301219540.9713@greenie.cheapcomplexdevices.com>
<1755.1112242072@sss.pgh.pa.us>
<424BA115.8050606@cheapcomplexdevices.com>
> > rm_pg@cheapcomplexdevices.com writes:
> streetname_lookup
> (for every street name used in the country)
> streetid | name | type
> ----------+--------+------
> 1 | Main | St
> 2 | 1st | St
>
Afa I'm concerned, I would add the column "city_id" since 2 different
streets in 2 different cities may have the same name.
Amicalement
Patrick
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: patrick.vedrines@adpcl.com, rm_pg@cheapcomplexdevices.com
Subject: Re: Left Outer Join much faster than non-outer Join?
In-Reply-To: <008001c535cb$939f48d0$1e0baf96@pcpatrickxp>
* 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