Simon Riggs <[EMAIL PROTECTED]> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance