Thread: Wisconsin Benchmark
Hi everyone, Has anyone tried using the Wisconsin PostgreSQL benchmark?? Is it good,reliable,accepted as a good benchmark??? Thanks in advance. David.
On Mar 26 Feb 2002 09:32, you wrote: > Hi everyone, > > Has anyone tried using the Wisconsin PostgreSQL > benchmark?? > > Is it good,reliable,accepted as a good > benchmark??? Where can that benchmark be found? -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------
f2160528@est.fib.upc.es writes: > Has anyone tried using the Wisconsin PostgreSQL > benchmark?? > Is it good,reliable,accepted as a good > benchmark??? If you're speaking of src/test/bench/, it's a pretty old and crufty implementation. (For one thing, it runs the benchmark in a standalone backend, not in the normal multiuser environment, which already counts as cooking the results IMHO. Someone ought to clean it up.) If you're speaking of the Wisconsin benchmark in the abstract, I think it's not used very much anymore; people seem to put more faith in the various TPC benchmark designs. regards, tom lane
On Tue, Feb 26, 2002 at 10:39:33AM -0500, Tom Lane wrote: > If you're speaking of the Wisconsin benchmark in the abstract, I think > it's not used very much anymore; people seem to put more faith in the > various TPC benchmark designs. There are some explanations of why people don't like Wisconsin much any more, and what sorts of workarounds you can use with Wisconsin in order to address some of those worries, at http://www.benchmarkresources.com/handbook/4.html A -- ---- Andrew Sullivan 87 Mowat Avenue Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M6K 3E3 +1 416 646 3304 x110
Andrew Sullivan wrote: > > On Tue, Feb 26, 2002 at 10:39:33AM -0500, Tom Lane wrote: > > > If you're speaking of the Wisconsin benchmark in the abstract, I think > > it's not used very much anymore; people seem to put more faith in the > > various TPC benchmark designs. > > There are some explanations of why people don't like Wisconsin much > any more, and what sorts of workarounds you can use with Wisconsin in > order to address some of those worries, at > > http://www.benchmarkresources.com/handbook/4.html About here I'll put in a plug for the "Open Source Database Benchmark" (osdb.sourceforge.net), which has a small and active developer base, implements the AS3AP database benchmark, and runs on Linux. Due to the recent efforts of the developers, it's ability to be ported to other platforms is really coming along (if you're a decent C coder, you can probably get it running on Windows, *BSD, AIX, etc without too much effort). It's a true multi-user database benchmark, and is working on PostgreSQL, and MySQL, and I think Informix is now working too. Hope that's helpful. :-) Regards and best wishes, Justin Clift > A > > -- > ---- > Andrew Sullivan 87 Mowat Avenue > Liberty RMS Toronto, Ontario Canada > <andrew@libertyrms.info> M6K 3E3 > +1 416 646 3304 x110 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi