Postgres Pro
Downloads
Home   >   mailing lists

Re: amount of join's and sequential access to the tables involved - Mailing list pgsql-sql

From Tom Lane
Subject Re: amount of join's and sequential access to the tables involved
Date
Msg-id 20152.1326296428@sss.pgh.pa.us
Whole thread Raw
In response to amount of join's and sequential access to the tables involved  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Responses Re: amount of join's and sequential access to the tables involved  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Re: amount of join's and sequential access to the tables involved  (Gerardo Herzig <gherzig@fmed.uba.ar>)
List pgsql-sql
Tree view 
Gerardo Herzig <gherzig@fmed.uba.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

pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: amount of join's and sequential access to the tables involved
Next
From: Gerardo Herzig
Date:
Subject: Re: amount of join's and sequential access to the tables involved