Received: from sdns.nudt.edu.cn (sdns.nudt.edu.cn [202.197.0.181]) by hub.org (8.9.1/8.9.1) with ESMTP id TAA12579 for ; Tue, 8 Dec 1998 19:28:35 -0500 (EST) (envelope-from sqyang@nudt.edu.cn) Received: from S ([202.197.11.54]) by sdns.nudt.edu.cn (Netscape Messaging Server 3.6) with SMTP id AAA5116 for ; Wed, 9 Dec 1998 08:29:16 +0800 Message-ID: <001501be230b$3a3f6c40$360bc5ca@S.Q.Yang.nudt.edu.cn> From: "Yang Shuqiang" To: Subject: hash table out of memory Date: Wed, 9 Dec 1998 08:31:10 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0012_01BE234E.467BEAE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 This is a multi-part message in MIME format. ------=_NextPart_000_0012_01BE234E.467BEAE0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Hello: I have two tables: tenk1 and tenk2. I start postmaster with command "postmaster -o'-fm -fn' -S" to ensure that the backend will produce hash join planner. Then I enter psql and execute the statement:=20 select count(*) from tenk1,tenk2 where tenk1.unique1=3Dtenk2.unique2; It reports: ERROR: hash table out of memory. Use -B parameter to increase buffers. Then I start postmaster with command "postmaster -B1024 -o'-fm -fn' -S" to increase the buffer. But it still reports the error. The tables I used each has 16 fields and each contains 100000 tuples. How can I overcome this problem? Thanks in advances. email address: sqyang@nudt.edu.cn ------=_NextPart_000_0012_01BE234E.467BEAE0 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable
Hello:
I have two tables: tenk1 and tenk2. I start postmaster = with=20 command
"postmaster -o'-fm -fn' -S" to ensure that the = backend will=20 produce
hash join planner. Then I enter psql and execute the = statement:=20
    select count(*)
    from=20 tenk1,tenk2
    where = tenk1.unique1=3Dtenk2.unique2;
It=20 reports:
ERROR:  hash table out of memory. Use -B parameter to = increase=20 buffers.

Then I start postmaster with command
"postmaster = -B1024=20 -o'-fm -fn' -S" to increase the buffer. But it still
reports the = error.

The tables I used each has 16 fields and each contains = 100000=20 tuples.

How can I overcome this problem?

Thanks in=20 advances.
email address: sqyang@nudt.edu.cn
------=_NextPart_000_0012_01BE234E.467BEAE0--