Robert Haas <robertmhaas@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
