Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2]) by hub.org (8.8.8/8.8.8) with SMTP id JAA04793 for ; Thu, 15 Oct 1998 09:48:32 -0400 (EDT) (envelope-from pierre@desertmoon.com) From: pierre@desertmoon.com Received: (qmail 29939 invoked by uid 100); 15 Oct 1998 13:53:23 -0000 Message-ID: <19981015135323.29938.qmail@desertmoon.com> Date: 15 Oct 1998 06:53:23 -0700 Subject: Cluster(ing) to help joins? To: pgsql-sql@postgreSQL.org Date: Thu, 15 Oct 1998 06:53:23 -0700 (MST) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi there. I'm working with a DB under 6.3.2 that has a little over 2million rows of data spread across 8-10 tables. The question I have is when I attempt to join more than 3 tables I get a HUGE performence hit, even if the number of rows returned by the first set of clauses is small. If I perform part of the join minus a single table the performance is great. So why is this? Can using clusters help in this kind of situation? I did discover that building multi-key indexes did help the performance a bit but it is still way too slow at times. Oh...and can someone tell me what this error message means? ERROR: ExecInitIndexScan: both left and right op's are rel-vars Thanks for any and all help... -=pierre