Re: [PERFORM] Open request for benchmarking input (fwd)

2005-12-02 Thread Qingqing Zhou
"David Lang" <[EMAIL PROTECTED]> wrote > here are the suggestions from the MySQL folks, what additional tests > should I do. > I think the tests you list are enough in this stage, Regards, Qingqing ---(end of broadcast)--- TIP 9: In versions b

Re: [PERFORM] Open request for benchmarking input (fwd)

2005-12-01 Thread David Lang
here are the suggestions from the MySQL folks, what additional tests should I do. I'd like to see some tests submitted that map out when not to use a particular database engine, so if you have a test that you know a particular database chokes on let me know (bonus credibility if you include t

Re: [PERFORM] Open request for benchmarking input

2005-11-27 Thread David Lang
On Sun, 27 Nov 2005, Andreas Pflug wrote: David Lang wrote: Postgres needs to work on the low end stuff as well as the high end stuff or people will write their app to work with things that DO run on low end hardware and they spend much more money then is needed to scale the hardware up rat

Re: [PERFORM] Open request for benchmarking input

2005-11-27 Thread Andreas Pflug
David Lang wrote: These boxes don't look like being designed for a DB server. The first are very CPU bound, and the third may be a good choice for very large amounts of streamed data, but not optimal for TP random access. I don't know what you mean when you say that the first ones are CPU bo

Re: [PERFORM] Open request for benchmarking input

2005-11-27 Thread Steinar H. Gunderson
On Sat, Nov 26, 2005 at 01:57:47PM -0500, Qingqing Zhou wrote: > Don't forget TPCC (data > memory, with intensive updates). So the benchmarks > in my mind include TPCC, TPCH and TPCW. I'm lost in all those acronyms, but am I right in assuming that none of these actually push the planner very hard

[PERFORM] Open request for benchmarking input

2005-11-26 Thread David Lang
These boxes don't look like being designed for a DB server. The first are very CPU bound, and the third may be a good choice for very large amounts of streamed data, but not optimal for TP random access. I don't know what you mean when you say that the first ones are CPU bound, they have far m

Re: [PERFORM] Open request for benchmarking input

2005-11-26 Thread David Lang
by the way, this is the discussion that promped me to start this project http://lwn.net/Articles/161323/ David Lang ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PERFORM] Open request for benchmarking input

2005-11-26 Thread David Lang
Ok, I've subscribed (hopefully list volume won't kill me :-) I'm covering several things in this message since I didn't receive the prior messages in the thread first off these benchamrks are not being sponsered by my employer, they need the machines burned in and so I'm going to use them for

Re: [PERFORM] Open request for benchmarking input

2005-11-26 Thread Andreas Pflug
Qingqing Zhou wrote: "Jeff Frost" <[EMAIL PROTECTED]> wrote "The hardware I have available is as follows: * 2x dual Opteron 8G ram, 2x144G 15Krpm SCSI * 2x dual Opteron 8G ram, 2x72G 15Krpm SCSI * 1x dual Opteron 16G ram, 2x36G 15Krpm SCSI 16x400G 7200rpm SATA (2) The hardware confi

Re: [PERFORM] Open request for benchmarking input

2005-11-26 Thread Ron
At 03:15 PM 11/26/2005, Luke Lonergan wrote: I suggest specifying a set of basic system / HW benchmarks to baseline the hardware before each benchmark is run. This has proven to be a major issue with most performance tests. My pick for I/O is bonnie++. Your equipment allows you the opportunit

Re: [PERFORM] Open request for benchmarking input

2005-11-26 Thread Luke Lonergan
Jeff, Qingqing, On 11/26/05 10:57 AM, "Qingqing Zhou" <[EMAIL PROTECTED]> wrote: > > "Jeff Frost" <[EMAIL PROTECTED]> wrote >> >> Did you folks see this article on Slashdot with a fellow requesting input >> on what sort of benchmarks to run to get a good Postgresql vs Mysql >> dataset? Perhaps

Re: [PERFORM] Open request for benchmarking input

2005-11-26 Thread Qingqing Zhou
"Jeff Frost" <[EMAIL PROTECTED]> wrote > > Did you folks see this article on Slashdot with a fellow requesting input > on what sort of benchmarks to run to get a good Postgresql vs Mysql > dataset? Perhaps this would be a good opportunity for us to get some good > benchmarking done. > "The har

[PERFORM] Open request for benchmarking input

2005-11-26 Thread Jeff Frost
Did you folks see this article on Slashdot with a fellow requesting input on what sort of benchmarks to run to get a good Postgresql vs Mysql dataset? Perhaps this would be a good opportunity for us to get some good benchmarking done. Here's the article link and top text: http://ask.slashdot.