DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=rq5xkXwuPKxA4ake7FE/GUMoZe5GRrPKpgW/iWdqseOqcOfAEUCHFNP7lZFhA7QMjN
	bPZ70nObnqplL5HZtnb6zDxair9Qi2Hn/zaDQM+yFbfoCW1lUDyoZgI1CfG5PgIsL/AX
	/yVCuCr3RCdDw56K/ECuRHM7nRBQMOVRMC3Tg=
MIME-Version: 1.0
In-Reply-To: <4BE86EBA.3070205@fmed.uba.ar>
References: <4BE8530C.6030605@fmed.uba.ar>
	<AANLkTimCg_3fZ_dAHPcFQalvgO6SaFeEHHY62g45hv95@mail.gmail.com>
	<4BE86EBA.3070205@fmed.uba.ar>
Date: Mon, 10 May 2010 15:35:17 -0600
Message-ID: <AANLkTimzy8SjmlUYWWLmr85S8xZ-hB3tUIQ49gEmjQx_@mail.gmail.com>
Subject: Re: advice on query joining 10 tables
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Gerardo Herzig <gherzig@fmed.uba.ar>
Cc: postgres list <pgsql-sql@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Mon, May 10, 2010 at 2:38 PM, Gerardo Herzig <gherzig@fmed.uba.ar> wrote=
:
> Scott Marlowe wrote:
>> On Mon, May 10, 2010 at 12:40 PM, Gerardo Herzig <gherzig@fmed.uba.ar> w=
rote:
>>> 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 fo=
llow?
>>
>> log long running queries for later analysis?
>>
>>> 2) Should i try to join the bigger tables last in the query?
>>
>> The query planner can do that for you automatically.
>>
>>> 3) There is some place for understanding EXPLAIN better?
>>
>> http://explain.depesz.com/
>>
>> Here and the docs? =A0I've found it pretty easy to post one here and ask
>> for help and get it on why a query isn't running well. =A0Note that
>> explain analyze is much preferred to plain explain.
>>
> Well, thanks Tom and Scott for the answers. I will take some more time
> reading the docs. Im looking more to know better, rather than just
> waiting to someone to point out my errors.

Also, search the pgsql archives for "explain analyze" for lots of
posts.  You can learn quite a bit trawling the archives like that.