> In fact the probleme is when i have more than 11 tables in the query...
Please post the EXPLAIN ANALYZE results of the problematic query, as well as the definition of any views it uses. Also, SHOW from_collapse_limit; ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html