Simon Riggs <simon@xxxxxxxxxxxxxxx> writes: > I have a complex query where making a small change to the SQL increases > run-time by > 1000 times. > The first SQL statement is of the form > A JOIN B ON (a.id = b.id) LEFT JOIN C ON (a.id = c.id) > and the second is like this > A JOIN B ON (a.id = b.id) LEFT JOIN C ON (b.id = c.id) > the only difference is the substitution of a -> b Please provide an actual test case. regards, tom lane
