Re: Left Outer Join much faster than non-outer Join?

From: "Patrick Vedrines" <patrick(dot)vedrines(at)adpcl(dot)com>
To: "Ron Mayer" <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Left Outer Join much faster than non-outer Join?
Date: 2005-03-31 08:28:11
Message-ID: 008001c535cb$939f48d0$1e0baf96@pcpatrickxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > rm_pg(at)cheapcomplexdevices(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-03-31 09:01:01 Re: fine tuning for logging server
Previous Message Ron Mayer 2005-03-31 08:15:55 Re: Left Outer Join much faster than non-outer Join?