Re: Block nested loop join
| От | Bramandia Ramadhana |
|---|---|
| Тема | Re: Block nested loop join |
| Дата | |
| Msg-id | 700260640810100145k14610225k36e668be18ea6225@mail.gmail.com обсуждение |
| Ответ на | Re: Block nested loop join (Gregory Stark <stark@enterprisedb.com>) |
| Ответы |
Re: Block nested loop join
|
| Список | pgsql-hackers |
Thanks for the clarifications.
Just for curiosity, is there any reason of not having block nested-loop join implementation? Is it rarely useful?
As far as I am aware of, in the case of cross product of two tables, block nested-loop join is the most efficient algorithm.
Regards,
Bramandia R.
Just for curiosity, is there any reason of not having block nested-loop join implementation? Is it rarely useful?
As far as I am aware of, in the case of cross product of two tables, block nested-loop join is the most efficient algorithm.
Regards,
Bramandia R.
On Fri, Oct 10, 2008 at 3:30 PM, Gregory Stark <stark@enterprisedb.com> wrote:
We do support Hash Join though so I think the only difference is that we can't
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> Does postgresql support block nested loop join?
>
> Nope.
use the hash join for cartesian joins.
--
Gregory StarkEnterpriseDB http://www.enterprisedb.comAsk me about EnterpriseDB's PostGIS support!
В списке pgsql-hackers по дате отправления: