Gerardo Herzig <[email protected]> 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
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
