From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | PSA: "tenk1" and other similar regression test tables are from the Wisconsin Benchmark |
Date: | 2019-01-15 21:52:11 |
Message-ID: | CAH2-Wzmff7hdfoAp41TKNF5D_Cn4nCZiXM2HubAakj3u+gKK1Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I recently purchased a copy of "The Benchmark Handbook", a book from
the early 1990s that was edited by Jim Gray. It features analysis of
the Wisconsin Benchmark in chapter 3 -- that's a single client
benchmark that famously showed real limitations in the optimizers that
were current in the early to mid 1980s. The book describes various
limitations of Wisconsin as a general purpose benchmark, but it's
still interesting in other ways, then and now. The book goes on to say
that it is still often used in regression tests.
I see that we even had a full copy of the benchmark until it was torn
out by commit a05a4b47 in 2009. I don't think that anybody will be
interested in the Benchmark itself, but the design of the benchmark
may provide useful context. I could imagine somebody with an interest
in the optimizer finding the book useful. I paid about $5 for a second
hand copy of the first edition, so it isn't a hard purchase for me to
justify.
--
Peter Geoghegan
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-01-15 22:04:02 | Re: Ryu floating point output patch |
Previous Message | Thomas Munro | 2019-01-15 21:37:35 | Re: pgsql: Update ssl test certificates and keys |