X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3C5509DC9E7 for ; Thu, 26 Jan 2006 12:33:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50759-01 for ; Thu, 26 Jan 2006 12:33:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203]) by postgresql.org (Postfix) with ESMTP id 0DF419DC9D1 for ; Thu, 26 Jan 2006 12:33:34 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so370523wri for ; Thu, 26 Jan 2006 08:33:34 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lTh1Pbb0swSWzto/ysGm6f0kip5bqOlSYD3pXYmUC87mkxB/xhneLzoFz5kmyqv4ITcweqgbIOLL4pLUy6eP7bCGn0J4vPtgaON8jDnI/7bmfZ6aVsPIV7iB+WU+x+XV0W2kDSphUP6baHo8k0VTasDUa6UZAjdKBzSw9uubtYE= Received: by 10.54.69.14 with SMTP id r14mr2600776wra; Thu, 26 Jan 2006 08:33:34 -0800 (PST) Received: by 10.54.93.8 with HTTP; Thu, 26 Jan 2006 08:33:34 -0800 (PST) Message-ID: Date: Thu, 26 Jan 2006 11:33:34 -0500 From: Jaime Casanova To: "J@planeti.biz" Subject: Re: [PERFORM] Query optimization with X Y JOIN Cc: pgsql-sql@postgresql.org In-Reply-To: <008001c62295$156b8fc0$0d310d05@fatchubby> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <786c2f6d0601260206k2201a548p48af7c7fc085d3b2@mail.gmail.com> <005d01c6228f$3772dca0$0d310d05@fatchubby> <43D8F4FD.4040703@modgraph-usa.com> <008001c62295$156b8fc0$0d310d05@fatchubby> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.677 required=5 tests=[AWL=-0.492, BIZ_TLD=1.169] X-Spam-Score: 0.677 X-Spam-Level: X-Archive-Number: 200601/186 X-Sequence-Number: 23975 On 1/26/06, J@planeti.biz wrote: > If I want my database to go faster, due to X then I would think that the > issue is about performance. I wasn't aware of a paticular constraint on X= . > > I have more that a rudementary understanding of what's going on here, I w= as > just hoping that someone could shed some light on the basic principal of > this JOIN command and its syntax. Most people I ask, don't give me straig= ht > answers and what I have already read on the web is not very helpful thus > far. http://www.postgresql.org/docs/current/static/sql-select.html -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)