hello.
I think that left/right joins and limit may be optimized.When there aren't WHERE conditions this may be executed as below:
Limit NMerge Left Join Sort Top N Bitmap Heap Scan ... Sort Bitmap Heap Scan ...
------------pasman