Re: postgresql shared buffers

Praveen Kumar N wrote:
> On Fri, 8 Sep 2006, Heikki Linnakangas wrote:
>
>> Looks like Alvaro guessed right. It reads both relations in sequence, 
>> sorts them in temporary storage, outside bufmgr, and then does a 
>> merge join on the sorted inputs.
>
> could you tell me how can we trace that? I mean which functions shall 
> I checkout for that.

The sort code is in src/backend/utils/sort/tuplesort.c and logtape.c. 
Can't remember function names from the top of my head.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com