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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance