John Lumby <johnlumby@xxxxxxxxxxx> writes: > Meanwhile, I have one other suggestion aimed specifically at problematic CTEs: > Would it be reasonable to provide a new Planner Configuration option : > enable_nestloop_cte_inner (boolean) > Enables or disables the query planner's use of nested-loop join plans in which a CTE is the inner. Sounds pretty badly thought out to me. There might be some cases where this would help, but there would be many more where it would be useless or counterproductive. The case that was discussed in the previous thread looked like it could be addressed by teaching the planner to drill down into CTEs to find variable referents, as it already does for subquery RTEs (cf examine_simple_variable in selfuncs.c). I'm not sure if your case is similar or not --- you didn't provide any useful amount of detail. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
