Changeset: 8621e269b67b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8621e269b67b Modified Files: sql/server/rel_optimizer.c Branch: Jun2020 Log Message:
Reverting my own changes, running rel_merge_rse optimizer more than once, causes performance degradation diffs (13 lines): diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c --- a/sql/server/rel_optimizer.c +++ b/sql/server/rel_optimizer.c @@ -9122,7 +9122,8 @@ optimize_rel(mvc *sql, sql_rel *rel, int rel = rel_visitor_topdown(sql, rel, &rel_split_outerjoin, &changes); if (gp.cnt[op_select] || gp.cnt[op_project]) - rel = rel_visitor_bottomup(sql, rel, &rel_merge_rse, &changes); + if (level == 1) /* only once */ + rel = rel_visitor_bottomup(sql, rel, &rel_merge_rse, &changes); if (gp.cnt[op_select] && gp.cnt[op_join] && /* DISABLES CODE */ (0)) rel = rel_visitor_topdown(sql, rel, &rel_push_select_down_join, &changes); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list