[feature request] left/right join + limit optimization

[pasman pasmański <pasman.p@xxxxxxxxx>]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general