<div dir="ltr">Hi all,<br /><br />I am new to postgresql. I am currently doing research to optimize the query
performanceof RDBMS, specifically postgresql. Hence, I am currently reading out the code to understand the
implementationof various query evaluation algorithm in postgresql.<br /><br />Currently, I am investigating the nested
loopjoin algorithm in nodeNestloop.c. After reading the code, my understanding is that it performs simple nested loop
join(not block nested loop join). Is this true? Does postgresql support block nested loop join? If it does, where is
it?I might miss some buffering/caching mechanism.<br /><br />I appreciate any helps/advice.<br /><br />Regards,<br
/><br/>Bramandia R.<br /><br /></div>