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

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