Received: from verde.onda.com.br (verde.onda.com.br [200.195.192.10]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA9Hw0s67800 for ; Thu, 9 Nov 2000 12:58:00 -0500 (EST) (envelope-from cdallacosta@bigfoot.com) Received: from terrificus (cmcta002p161.onda.com.br [200.195.205.161]) by verde.onda.com.br (8.8.8/8.8.8) with SMTP id PAA28447 for ; Thu, 9 Nov 2000 15:57:11 -0200 (EDT) Message-ID: <003b01c04a7f$78d80960$02ffa8c0@terrificus> From: "=?iso-8859-1?Q?Crist=F3v=E3o_B._B._Dalla_Costa?=" Cc: References: Subject: Re: [sql]Joins Date: Thu, 9 Nov 2000 15:59:48 -0300 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 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/78 X-Sequence-Number: 109 > I've had no problems really until about 8-12 tables joined when you might > tickle a bug in some versions of postgres which cause bogus plans to be > generated. I've had queries with over 25 joins and self-joins with no problems whatsoever.