pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (7+ messages)  latest in thread

Message-ID: <008001c535cb$939f48d0$1e0baf96@pcpatrickxp>
Permalink:  ../008001c535cb$939f48d0$1e0baf96@pcpatrickxp/
Also on:    postgresql.org/message-id/008001c535cb$939f48d0$1e0baf96@pcpatrickxp

 · 

reply

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