Better solution to the IN-list issue: instead of having an arbitrary cutoff,
treat Var and non-Var IN-list items differently. Only non-Var items are
candidates to go into an ANY(ARRAY) construct --- we put all Vars as separate
OR conditions on the grounds that that leaves more scope for optimization.
Per suggestion from Robert Haas.
parse_expr.c (r1.236 -> r1.237)
pgsql-committers by date
|Next:||From: Tom Lane||Date: 2008-10-26 02:46:30|
|Subject: pgsql: Better solution to the IN-list issue: instead of having an |
|Previous:||From: Tom Lane||Date: 2008-10-25 19:51:32|
|Subject: pgsql: Be a little smarter about qual handling for semi-joins: a qual |