[feature request] left/right join + limit optimization

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 N
Merge Left Join
  Sort Top N
    Bitmap Heap Scan
      ...
  Sort
    Bitmap Heap Scan
      ...


------------
pasman