Re: Left Outer Join much faster than non-outer Join? - Mailing list pgsql-performance

> > 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