Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA11647; Wed, 8 Jul 92 11:26:16 -0700
Date: Wed, 8 Jul 92 11:26:16 -0700
Message-Id: <9207081826.AA11647@postgres.Berkeley.EDU>
From: postgres@mailhost.cs.pdx.edu (Postgres Account)
Subject: Hashjoin again
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu


Thanks for your respones. I have further questions on hashjoin. When does
postgres create temporary file for overflow without aborting the query
for lacking of available memory? Where will the temporary file be located when
it is created? It seems that if the relation is large enough, postgres 
abords the query for lacking of memory first and never creates temp files.

I would appreciate your help.

--Shengsong Ni