Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-25 Thread Rodrigo E . De León Plicet
On Mon, Feb 23, 2009 at 1:29 PM, Sergio Lopez sergio.lo...@nologin.es wrote: El Sat, 21 Feb 2009 21:04:49 -0500 I've taken down the article and I'll bring up it again when I've collected new numbers. Please do, this subject is very interesting. Regards. -- Sent via pgsql-performance mailing

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-23 Thread Sergio Lopez
El Sat, 21 Feb 2009 21:04:49 -0500 Jonah H. Harris jonah.har...@gmail.com escribió: On Fri, Feb 20, 2009 at 8:40 PM, Denis Lussier denis.luss...@enterprisedb.com wrote: Hi all, As the author of BenchmarkSQL and the founder of EnterpriseDB I can assure you that BenchmarkSQL was

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-21 Thread Denis Lussier
Hi all, As the author of BenchmarkSQL and the founder of EnterpriseDB I can assure you that BenchmarkSQL was NOT written specifically for PostgreSQL.It is intended to be a completely database agnostic tpc-c like java based benchmark. However; as Jonah correctly points out in painstaking

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-21 Thread Jonah H. Harris
On Fri, Feb 20, 2009 at 8:40 PM, Denis Lussier denis.luss...@enterprisedb.com wrote: Hi all, As the author of BenchmarkSQL and the founder of EnterpriseDB I can assure you that BenchmarkSQL was NOT written specifically for PostgreSQL.It is intended to be a completely database

[PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Sergio Lopez
Hi, I've made a benchmark comparing PostgreSQL, MySQL and Oracle under three environments: GNU/Linux-x86, Solaris-x86 (same machine as GNU/Linux) and Solaris-SPARC. I think you might find it interesting:

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Alan Hodgson
On Friday 20 February 2009, Sergio Lopez sergio.lo...@nologin.es wrote: Hi, I've made a benchmark comparing PostgreSQL, MySQL and Oracle under three environments: GNU/Linux-x86, Solaris-x86 (same machine as GNU/Linux) and Solaris-SPARC. I think you might find it interesting:

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Sergio Lopez
El Fri, 20 Feb 2009 08:36:44 -0800 Alan Hodgson ahodg...@simkin.ca escribió: On Friday 20 February 2009, Sergio Lopez sergio.lo...@nologin.es wrote: Hi, I've made a benchmark comparing PostgreSQL, MySQL and Oracle under three environments: GNU/Linux-x86, Solaris-x86 (same machine as

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Jonah H. Harris
On Fri, Feb 20, 2009 at 6:28 AM, Sergio Lopez sergio.lo...@nologin.eswrote: Hi, I've made a benchmark comparing PostgreSQL, MySQL and Oracle under three environments: GNU/Linux-x86, Solaris-x86 (same machine as GNU/Linux) and Solaris-SPARC. I think you might find it interesting:

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Sergio Lopez
El Fri, 20 Feb 2009 12:39:41 -0500 Jonah H. Harris jonah.har...@gmail.com escribió: On Fri, Feb 20, 2009 at 6:28 AM, Sergio Lopez sergio.lo...@nologin.eswrote: Hi, I've made a benchmark comparing PostgreSQL, MySQL and Oracle under three environments: GNU/Linux-x86, Solaris-x86 (same

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Robert Haas
First of all, you need to do some research on the benchmark kit itself, rather than blindly downloading and using one. BenchmarkSQL has significant bugs in it which affect the result. I can say that authoritatively as I worked on/with it for quite awhile. Don't trust any result that comes

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Jonah H. Harris
On Fri, Feb 20, 2009 at 1:15 PM, Sergio Lopez sergio.lo...@nologin.eswrote: On the other hand, I've neved said that what I've done is the Perfect-Marvelous-Definitive Benchmark, it's just a personal project, and I don't have an infinite amount of time to invest on it. When you make comments

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Jonah H. Harris
On Fri, Feb 20, 2009 at 2:35 PM, Robert Haas robertmh...@gmail.com wrote: First of all, you need to do some research on the benchmark kit itself, rather than blindly downloading and using one. BenchmarkSQL has significant bugs in it which affect the result. I can say that authoritatively

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Jonah H. Harris
On Fri, Feb 20, 2009 at 2:48 PM, Jonah H. Harris jonah.har...@gmail.comwrote: Having this said, the benchmark is not as unfair as you thought. I've taken care to prepare all databases to meet similar values for their cache, buffers and I/O configuration (to what's possible given their

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Merlin Moncure
On Fri, Feb 20, 2009 at 2:48 PM, Jonah H. Harris jonah.har...@gmail.com wrote: On Fri, Feb 20, 2009 at 1:15 PM, Sergio Lopez sergio.lo...@nologin.es wrote: On the other hand, I've neved said that what I've done is the Perfect-Marvelous-Definitive Benchmark, it's just a personal project, and

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Jonah H. Harris
On Fri, Feb 20, 2009 at 3:40 PM, Merlin Moncure mmonc...@gmail.com wrote: ISTM you are the one throwing out unsubstantiated assertions without data to back it up. OP ran benchmark. showed hardware/configs, and demonstrated result. He was careful to hedge expectations and gave rationale for

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Robert Haas
On Fri, Feb 20, 2009 at 4:34 PM, Jonah H. Harris jonah.har...@gmail.com wrote: On Fri, Feb 20, 2009 at 3:40 PM, Merlin Moncure mmonc...@gmail.com wrote: ISTM you are the one throwing out unsubstantiated assertions without data to back it up. OP ran benchmark. showed hardware/configs, and

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Scott Marlowe
On Fri, Feb 20, 2009 at 2:54 PM, Robert Haas robertmh...@gmail.com wrote: On Fri, Feb 20, 2009 at 4:34 PM, Jonah H. Harris jonah.har...@gmail.com wrote: On Fri, Feb 20, 2009 at 3:40 PM, Merlin Moncure mmonc...@gmail.com wrote: ISTM you are the one throwing out unsubstantiated assertions

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Mark Kirkwood
Robert Haas wrote: The biggest flaw in the benchmark by far has got to be that it was done with a ramdisk, so it's really only measuring CPU consumption. Measuring CPU consumption is interesting, but it doesn't have a lot to do with throughput in real-life situations. ... and memory

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Sergio Lopez
El Fri, 20 Feb 2009 14:48:06 -0500 Jonah H. Harris jonah.har...@gmail.com escribió: On Fri, Feb 20, 2009 at 1:15 PM, Sergio Lopez sergio.lo...@nologin.eswrote: Having this said, the benchmark is not as unfair as you thought. I've taken care to prepare all databases to meet similar values

Re: [PERFORM] Benchmark comparing PostgreSQL, MySQL and Oracle

2009-02-20 Thread Sergio Lopez
El Fri, 20 Feb 2009 16:54:58 -0500 Robert Haas robertmh...@gmail.com escribió: On Fri, Feb 20, 2009 at 4:34 PM, Jonah H. Harris jonah.har...@gmail.com wrote: On Fri, Feb 20, 2009 at 3:40 PM, Merlin Moncure mmonc...@gmail.com wrote: ISTM you are the one throwing out unsubstantiated