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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend