X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A84B3536C5 for ; Thu, 31 Mar 2005 09:30:03 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51046-02 for ; Thu, 31 Mar 2005 08:29:55 +0000 (GMT) Received: from felix.adpcl.com (felix.adpcl.com [194.98.137.100]) by svr1.postgresql.org (Postfix) with ESMTP id BBE775296D for ; Thu, 31 Mar 2005 09:29:53 +0100 (BST) Received: from pcpatrickxp (unknown [150.175.11.30]) by felix.adpcl.com (Postfix) with SMTP id 9E3A57811; Thu, 31 Mar 2005 10:33:04 +0200 (DFT) Message-ID: <008001c535cb$939f48d0$1e0baf96@pcpatrickxp> From: "Patrick Vedrines" To: "Ron Mayer" Cc: References: <1755.1112242072@sss.pgh.pa.us> <424BA115.8050606@cheapcomplexdevices.com> Subject: Re: Left Outer Join much faster than non-outer Join? Date: Thu, 31 Mar 2005 10:28:11 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.144 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/677 X-Sequence-Number: 11382 > > 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