Received: from maia.hub.org (maia-4.hub.org [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id A3B0563334C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 10 May 2010 16:06:33 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 33827-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 10 May 2010 19:06:26 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1])
	by mail.postgresql.org (Postfix) with ESMTP id 6DC87633225
	for <pgsql-sql@postgresql.org>; Mon, 10 May 2010 16:06:26 -0300 (ADT)
Received: from [157.92.152.105] (unknown [157.92.152.105])
	by mail.fmed.uba.ar (Postfix) with ESMTP id 3D0FA42DABB
	for <pgsql-sql@postgresql.org>; Mon, 10 May 2010 15:04:50 -0300 (ART)
Message-ID: <4BE8530C.6030605@fmed.uba.ar>
Date: Mon, 10 May 2010 15:40:12 -0300
From: Gerardo Herzig <gherzig@fmed.uba.ar>
User-Agent: Thunderbird 2.0.0.6 (X11/20070801)
MIME-Version: 1.0
To: postgres list <pgsql-sql@postgresql.org>
Subject: advice on query joining 10 tables
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201005/33
X-Sequence-Number: 34081

Hi all. Im triyng to see if i can improve the performance of a query
(mainly a 10 table join)

1) Besides of triyng to use indexes, there is some rules of thumb to follow?

2) Should i try to join the bigger tables last in the query?

3) There is some place for understanding EXPLAIN better?

Thanks!
Gerardo