Anyone remember this?
Conversation
Replying to
PostgreSQL default today is 1024 so I guess that's "medium" 😀 but then I figure the OSS community knows their code doesn't just go to machines w TBs of mem and many dozens of cores... the code ends up on IOT embeded devs and raspberry pi gadgets too github.com/postgres/postg
1
4
Kinda fascinating that the tiny PostgreSQL regression test tables like tenk (10K) came originally from a (famous) benchmark ~4 decades ago: jimgray.azurewebsites.net/benchmarkhandb
(Maybe the same benchmark infamously intertwined with Oracle history?)
1
4
Apparently the Wisconsin benchmark tables are still widely used in DB system tests - or at least "The Benchmark Handbook" by Jim Gray says so. Even back in early 1990s WB was obsolete - but it had this legacy in regression tests. That's probably still generally the case today.
Data is synthetic, but allows you to get any selectivity that you want. Made Oracle look bad in the 1980s because it only had nestloop join at the time. Competitors already had merge + hash join. Not hard to understand why WB was unpopular with Oracle!
5