Re: amount of join's and sequential access to the tables involved

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: amount of join's and sequential access to the tables involved
Date: 2012-01-11 15:40:28
Message-ID: 20152.1326296428@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> writes:
> 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.

increase join_collapse_limit, perhaps?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gerardo Herzig 2012-01-11 16:06:34 Re: amount of join's and sequential access to the tables involved
Previous Message Gerardo Herzig 2012-01-11 15:36:32 amount of join's and sequential access to the tables involved