Postgres Pro
Downloads
Home   >   mailing lists

[feature request] left/right join + limit optimization - Mailing list pgsql-general

From pasman pasmański
Subject [feature request] left/right join + limit optimization
Date
Msg-id AANLkTinZEJOjXkmCOGQ5sKMjFvWvJxSjGdW4MEconChn@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: How to use pgbouncer
Next
From: Dario Beraldi
Date:
Subject: Re: Can the query planner create indexes?