Herwig Goemans <herwig.goemans@gmail.com> writes:
> Is there anyone who can help so that the mixed query has the same or
> equivalent execution plan (performance) as the ansi query ?
I think you need to raise join_collapse_limit and/or from_collapse_limit.
regards, tom lane