Author: radek Date: Thu Nov 1 20:49:25 2007 GMT Module: SOURCES Tag: HEAD ---- Log message: - patch for planner regression introduced in 8.2.5 (shows up with very large joins planned without geqo)
---- Files affected: SOURCES: postgresql-825_planner_regression.patch (NONE -> 1.1) (NEW) ---- Diffs: ================================================================ Index: SOURCES/postgresql-825_planner_regression.patch diff -u /dev/null SOURCES/postgresql-825_planner_regression.patch:1.1 --- /dev/null Thu Nov 1 21:49:25 2007 +++ SOURCES/postgresql-825_planner_regression.patch Thu Nov 1 21:49:20 2007 @@ -0,0 +1,14 @@ +# from http://archives.postgresql.org/pgsql-bugs/2007-10/msg00180.php +diff -c -r1.123.2.7 src/backend/optimizer/plan/initsplan.c +*** src/backend/optimizer/plan/initsplan.c 4 Oct 2007 20:44:55 -0000 1.123.2.7 +--- src/backend/optimizer/plan/initsplan.c 24 Oct 2007 20:34:08 -0000 +*************** +*** 625,630 **** +--- 625,631 ---- + * rel in the lower OJ's min_righthand, not its whole syn_righthand. + */ + if (bms_overlap(left_rels, otherinfo->syn_righthand) && ++ bms_overlap(clause_relids, otherinfo->syn_righthand) && + !bms_overlap(strict_relids, otherinfo->min_righthand)) + { + min_lefthand = bms_add_members(min_lefthand, ================================================================ _______________________________________________ pld-cvs-commit mailing list [email protected] http://lists.pld-linux.org/mailman/listinfo/pld-cvs-commit
