Re: PostgreSQL Advocacy, Thoughts and Comments

Hi;

The MySQL manual states that Joins perform better than subselects.  The
stated reason is that the planner can better optimize a join.

I am, however, very skeptical of this, and would generally assume things to
be the other way around.

How do subselects perform in relation to hash joins, etc?

Best Wishes,
Chris Travers