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 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 list (pgsql-performa

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" 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 NOT writt

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

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-20 Thread Sergio Lopez
El Fri, 20 Feb 2009 16:54:58 -0500 Robert Haas escribió: > On Fri, Feb 20, 2009 at 4:34 PM, Jonah H. Harris > wrote: > > On Fri, Feb 20, 2009 at 3:40 PM, Merlin Moncure > > wrote: > >> > >> ISTM you are the one throwing out unsubstantiated assertions > >> without data to back it up. OP ran ben

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" escribió: > On Fri, Feb 20, 2009 at 1:15 PM, Sergio Lopez > wrote: > > 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 co

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 access

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 wrote: > On Fri, Feb 20, 2009 at 4:34 PM, Jonah H. Harris > wrote: >> On Fri, Feb 20, 2009 at 3:40 PM, Merlin Moncure wrote: >>> >>> ISTM you are the one throwing out unsubstantiated assertions without >>> data to back it up. OP ran benchmark. showe

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 wrote: > On Fri, Feb 20, 2009 at 3:40 PM, Merlin Moncure 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 carefu

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 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 his analysis me

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 wrote: > On Fri, Feb 20, 2009 at 1:15 PM, Sergio Lopez > 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 I don't have an infinite amount of t

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 wrote: > 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 >> differences), and the I

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 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 as I > > worke

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 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 I don't have an infinite amount of time to invest on it. When you make comments such as "As for datab

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 come

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" escribió: > On Fri, Feb 20, 2009 at 6:28 AM, Sergio Lopez > 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 Sola

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 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: > > > http://blogs.nologin.es/s

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 escribió: > On Friday 20 February 2009, Sergio Lopez > 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

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

2009-02-20 Thread Alan Hodgson
On Friday 20 February 2009, Sergio Lopez 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: > > http://blogs.nologin.es/slopez/a

[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: http://blogs.nologin.es/slopez/archives/17-Benchmarking-Databases-I.-Volatile-Storage..html