Message-ID: <4BE86EBA.3070205@fmed.uba.ar>
Date: Mon, 10 May 2010 17:38:18 -0300
From: Gerardo Herzig <gherzig@fmed.uba.ar>
User-Agent: Thunderbird 2.0.0.6 (X11/20070801)
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: postgres list <pgsql-sql@postgresql.org>
Subject: Re: advice on query joining 10 tables
References: <4BE8530C.6030605@fmed.uba.ar>
	<AANLkTimCg_3fZ_dAHPcFQalvgO6SaFeEHHY62g45hv95@mail.gmail.com>
In-Reply-To: <AANLkTimCg_3fZ_dAHPcFQalvgO6SaFeEHHY62g45hv95@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Scott Marlowe wrote:
> On Mon, May 10, 2010 at 12:40 PM, Gerardo Herzig <gherzig@fmed.uba.ar> wrote:
>> 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?
> 
> 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?  I've found it pretty easy to post one here and ask
> for help and get it on why a query isn't running well.  Note 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.
By the way, that site is cute!

Thanks again!
Gerardo