hash join --- hash table out of memory - Mailing list pgsql-sql

From sqyang
Subject hash join --- hash table out of memory
Date
Msg-id 36664324.342C2BB@nudt.edu.cn
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: PETER PAULY
Date:
Subject: Odd characters in inserted data...
Next
From: Tom Lane
Date:
Subject: Re: Odd characters in inserted data...