Albe Laurenz wrote > […] > Experiment with raising join_collapse_limit and from_collapse_limit to 11. Thank you, this solve the problem. > Alternatively, optimize the join order by hand and don't tune the parameters. What is surprising is that there is no apparent/logical optimal strategy. Best regards, -- PI -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance