Clemens Eisserer <linuxhi...@gmail.com> writes: > I have a quite complex, performance sensitive query in a system with a > few (7) joins: > select .... from t1 left join t2 .... WHERE id IN (select ....)
Does it work as expected with one less join? If so, try increasing
join_collapse_limit ...
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
