[feature request] left/right join + limit optimization

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [feature request] left/right join + limit optimization
Date: 2010-12-21 13:06:47
Message-ID: AANLkTinZEJOjXkmCOGQ5sKMjFvWvJxSjGdW4MEconChn@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Dario Beraldi 2010-12-21 13:44:36 Re: Can the query planner create indexes?
Previous Message Adarsh Sharma 2010-12-21 12:45:44 How to use pgbouncer