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. On Fri, Oct 10, 2008 at 3:30 PM, Gregory Stark <[EMAIL PROTECTED]>wrote: > > Heikki Linnakangas <[EMAIL PROTECTED]> writes: > > >> Does postgresql support block nested loop join? > > > > Nope. > > We do support Hash Join though so I think the only difference is that we > can't > use the hash join for cartesian joins. > > -- > Gregory Stark > EnterpriseDB http://www.enterprisedb.com > Ask me about EnterpriseDB's PostGIS support! >
