hash join --- hash table out of memory

From: sqyang <sqyang(at)nudt(dot)edu(dot)cn>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: hash join --- hash table out of memory
Date: 1998-12-03 07:52:04
Message-ID: 36664324.342C2BB@nudt.edu.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Filipe 1998-12-03 08:59:21 Re: [SQL] Query to eliminate duplicates
Previous Message David Hartwig 1998-12-03 02:24:37 Re: [SQL] Please help: How to determine largest of two numbers in a query?