X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 7E49B92514D for ; Tue, 20 May 2003 13:49:46 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 38660-04 for ; Tue, 20 May 2003 13:49:43 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by developer.postgresql.org (Postfix) with ESMTP id 2EEA8924D2D for ; Tue, 20 May 2003 13:49:43 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id B63A7D610; Tue, 20 May 2003 10:49:42 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id ABB535C0C; Tue, 20 May 2003 10:49:42 -0700 (PDT) Date: Tue, 20 May 2003 10:49:42 -0700 (PDT) From: Stephan Szabo To: ww zz Cc: Subject: Re: how to do this query? In-Reply-To: <20030520171940.63419.qmail@web41805.mail.yahoo.com> Message-ID: <20030520104746.D69760-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/398 X-Sequence-Number: 13563 On Tue, 20 May 2003, ww zz wrote: > another question is: > if I do left outer join on a few big tables, will it > be very slow? In general, it shouldn't be particularly, or at least not particularly worse than an inner join that gave the same number of result rows.