Le 16/03/2010 16:52, Tom Lane a écrit :
> Sometime in the future they might generate the same plan. Right now the
> planner's ability to optimize sub-SELECTs is pretty limited, and so you
> typically get a nestloop-like plan even if some other join style would
> be faster.
OK, thanks for the clarification.
Should joins always be considered better than subselects then ?
I like the readability of subselects and I think I use them more often
than joins when I have the choice, so maybe I should check and change
all my queries ?