Received: from out5.ibm.net (out5.ibm.net [165.87.194.243]) by hub.org (8.9.1/8.9.1) with ESMTP id WAA23669 for ; Mon, 26 Oct 1998 22:39:46 -0500 (EST) (envelope-from pierre@desertmoon.com) Received: from [32.100.167.79] (slip-32-100-167-79.tx.us.ibm.net [32.100.167.79]) by out5.ibm.net (8.8.5/8.6.9) with SMTP id DAA95886 for ; Tue, 27 Oct 1998 03:39:42 GMT Message-Id: <199810270339.DAA95886@out5.ibm.net> Subject: Joining bug???? Date: Mon, 26 Oct 1998 21:39:44 -0600 x-mailer: Claris Emailer 2.0v3, January 22, 1998 From: pierre To: Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" I've been attempting to get my DB tuned to handle joins as best as possible. However, no matter which way I try to perform the joins, if I attempt to join more than two or three tables the joins becomes unbearably long not matter how many indexes I create in however many ways. My only solution was to create a hybrid table that contains the join of all of the tables I'm searching on with multi-keyed indexes. This is a VERY kludgy solution that makes changing the keys to my DB hard to change. IS there a problem with postgresql in performing joins? Is there a fix? What gives? -=pierre