Jakub Ouhrabka <[EMAIL PROTECTED]> writes: > I've also tried your last patch but still for some queries there is long > planning time, e.g. more than 30s on a fast machine for query with 14 > regularly JOINed tables plus 8 tables are LEFT OUTER JOINed (all normal > joins are followed by all outer joins). All joins are constrained on > pk/fk. Should this case run faster or is it simply too much for > geqo=off? Shall I prepare a test case?
By "last patch" you mean http://archives.postgresql.org/pgsql-committers/2007-10/msg00409.php ? If so that's about as fast as it's likely to get. 22 tables is well beyond what I'd consider reasonable to run through the exhaustive planner. You should try geqo again. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
