Received: from dns.whnet.edu.cn (dns.whnet.edu.cn [202.112.20.131]) by hub.org (8.9.1/8.9.1) with SMTP id CAA29475 for ; Mon, 30 Nov 1998 02:49:51 -0500 (EST) (envelope-from sqyang@nudt.edu.cn) Received: from ns (ns.csit.edu.cn) by dns.whnet.edu.cn (5.x/SMI-SVR4) id AA08711; Mon, 30 Nov 1998 14:47:53 +0800 Received: from ysq ([202.197.11.54]) by ns (4.1/SMI-4.1) id AA22166; Mon, 30 Nov 98 15:48:05 CST Sender: post64@nudt.edu.cn Message-Id: <36664324.342C2BB@nudt.edu.cn> Date: Thu, 03 Dec 1998 15:52:04 +0800 From: sqyang Organization: GalaxyDB Cor. X-Mailer: Mozilla 3.01Gold (X11; I; Linux 2.0.30 i686) Mime-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: hash join --- hash table out of memory Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi: I had two tables tenk1 and tenk2. Tenk1 contains 25000 tuples. Tenk2 contains 30000 tuples. I use "postmaster -S -o'-fm -fn'" to start postmaster. Then ,when I execute the following query: select count(*) from tenk1,tenk2 where tenk1.unique1=tenk2.unique2; it reports: hash table out of memory. Use -B parameter to increase buffers. Then I use -B256 to increase buffers. But it also report the error messages. Is there any effort taken to avoid such errors? Thanks in advance! S.Q.Yang