Craig James <craig_james@xxxxxxxxxxxxxx> writes: > My guess (and it's just a wild guess) is that the "left join" is > forcing a sequence scan or something. No, that's forcing the other join to be done in toto because it can't reorder the left join and regular join. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
