Re: [HACKERS] Hashjoin status report

Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> We already have a good example for this "hash table out of memory. Use
> -B parameter to increase buffers" syndrome in our source tree. Go
> src/test/bench, remove "-B 256" from the last line of runwisc.sh then
> run the test. The "-B 256" used to not be in there. That was added by
> me while fixing the test suit and elog() (see included posting).  I
> don't see the error message in 6.4.2. I guess this is due to the
> change of the optimizer.

> IMHO, we should fix this before 6.5 is out, or should change the
> default settings of -B to 256 or so, this may cause short of shmem,
> however.

It's fixed --- do you want to remove -B 256 from the test suite?
        regards, tom lane