The following bug has been logged online:

Bug reference: 1238
Logged by: A Wu

Email address: sunwukong (AT) ieee (DOT) org

PostgreSQL version: 8.0 Beta

Operating system: Linux 2.6.7-gentoo-r14 x86_64

Description: postgres option -Q used in src/test/bench

Details:

src/test/bench/create.sh and src/test/bench/runwisc.sh both invoke
"postgres" with a -Q option which is not supported in 8.0 Beta1. Deleting -Q
from both files allows the scripts to run to completion.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
These scripts really need to be thrown away or rewritten entirely.
Benchmarks against a standalone backend are not interesting in the real
world. I doubt anyone has tried to run these in the past five years...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

I removed the -Q mention in the comments but Tom already fixed this in
early September.

---------------------------------------------------------------------------

PostgreSQL Bugs List wrote:
--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Bruce Momjian <pgman (AT) candle (DOT) pha.pa.us> writes:
Actually, I deliberately left that comment alone, since it appeared to
me to be a statement of historical fact --- ie, that *was* what they did
for some now-forgotten paper --- not a recommendation of how to do
things now. It's a judgment call though.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Tom Lane wrote:
Yea, I just remove the entire comment. It is just too long to be
relevant, no?

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html