Gerardo Herzig <gher...@fmed.uba.ar> writes: > Hi all. Im triyng to see if i can improve the performance of a query > (mainly a 10 table join)
One easy thing to try is increase from_collapse_limit and/or join_collapse_limit to 10 or more. That will result in longer planning time but might let the planner find a better plan for this query. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql