Robert Haas <robertmh...@gmail.com> writes: > Well, when I was testing, I believe I observed that an n-way join with > 1 cross join was slower to plan than an n-way join with no cross > joins. ISTM that it should actually be faster, because you should > plan it like an (n-1)-way join and then do the cross join at the end.
It's not entirely clear to me what case you're describing, but I wonder whether this was a "flat" join problem or restricted by the collapse limits. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers