Re: [HACKERS] Hashjoin status report - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Hashjoin status report
Date
Msg-id 26486.927482793@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Hashjoin status report  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: " eV!L (John)"
Date:
Subject: Could anyone tell me what tis news-group is about?
Next
From: Bruce Momjian
Date:
Subject: Wisconsin -B parameter