Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 2A114989B4D
	for <pgsql-sql@postgresql.org>; Wed, 11 Jan 2012 11:37:41 -0400 (AST)
Received: from mail.fmed.uba.ar ([157.92.152.1])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gherzig@fmed.uba.ar>) id 1Rl0F8-0005Ee-Fg
	for pgsql-sql@postgresql.org; Wed, 11 Jan 2012 15:37:41 +0000
Received: from [157.92.152.105] (unknown [157.92.152.105])
	by mail.fmed.uba.ar (Postfix) with ESMTP id E39E84A4BF4
	for <pgsql-sql@postgresql.org>; Wed, 11 Jan 2012 12:33:09 -0200 (ARST)
Subject: amount of join's and sequential access to the tables involved
From: Gerardo Herzig <gherzig@fmed.uba.ar>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Date: Wed, 11 Jan 2012 12:36:32 -0300
Message-ID: <1326296192.24629.12.camel@inca.fmed.uba.ar>
Mime-Version: 1.0
X-Mailer: Evolution 2.30.1.2 
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.3 (--)
X-Archive-Number: 201201/37
X-Sequence-Number: 36208

Hi all. Im working on a 'simple' query with 7, 8 left joins. After the
9nth join or so, explain analyze became to show the plan with many
tables being read in sequential fashion. Of course, this slows down the
query response in a factor on 10.

I can alter the order in wich the join's are appended, allways with the
same result.

So,it looks like a resources config situation.

Wich config variables are involved in the use of hash joins?

(I dont have access right now to the server running pg, so i cannot show
query plan nor pg configuration)

Thanks!

Gerardo