X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E99369FB2D2 for ; Sat, 29 Jul 2006 15:09:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85176-06 for ; Sat, 29 Jul 2006 15:09:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 7752A9FA004 for ; Sat, 29 Jul 2006 15:09:22 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id i11so50463nzi for ; Sat, 29 Jul 2006 11:09:19 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=NIDJ/hEzwESB2At5YJTxDOS61G5oQ7knO5Xse5D8VdwTJOybQNEzAjNfESv8zMsFyDmJj/sUep/vhHSjDfav+e741f0aSppqCYs48n6e5jDPs895BdClw8OrXemBBOI3d+PgBxFT01LDGhrxF7ntIMgiPOXCOdOS/L6W4VYssFk= Received: by 10.65.250.14 with SMTP id c14mr898354qbs; Sat, 29 Jul 2006 11:09:15 -0700 (PDT) Received: by 10.64.179.18 with HTTP; Sat, 29 Jul 2006 11:09:15 -0700 (PDT) Message-ID: <5f820f750607291109g6df92f86lf7d8ee7db012c3d4@mail.gmail.com> Date: Sat, 29 Jul 2006 14:09:15 -0400 From: "Denis Lussier" To: "Leigh Dyer" Subject: Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Cc: pgsql-performance@postgresql.org, Mikael.Carneholm@wirelesscar.com In-Reply-To: <44CA1C81.8060703@eclinic.com.au> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15003_27600131.1154196555239" References: <7F10D26ECFA1FB458B89C5B4B0D72C2B4E4D8C@sesrv12.wirelesscar.com> <44CA1C81.8060703@eclinic.com.au> X-Google-Sender-Auth: 77a04140f5c923f9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.278 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/284 X-Sequence-Number: 20144 ------=_Part_15003_27600131.1154196555239 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline > systems could send me their bonnie + benchmarksql results! I am one of the authors of BenchmarkSQL, it is similar to a DBT2. But, its very easy to use (&/or abuse). It's a multithreaded Java Swing client that can run the exact same benchmark (uses JDBC prepared statements) against Postgres/EnterpriseDB/Bizgres, MySQueeL, Horacle, Microsloth, etc, etc. You can find BenchmarkSQL on pgFoundry and SourceForge. As expected, Postgres is good on this benchmark and is getting better all the time. If you run an EnterpriseDB install right out of the box versus a PG install right out of the box you'll notice that EnterpriseDB outperforms PG by better than 2x. This does NOT mean that EnterpriseDB is 3x faster than Postgres... EnterpriseDB is the same speed as Postgres. We do something we call "Dynatune" at db startup time. The algorithm is pretty simple in our current GA version and really only considers the amount of RAM, SHARED Memory, and machine usage pattern. Manual tuning is required to really optimize performance.... For great insight into the basics of quickly tuning PostgreSQL for a reasonable starting point, check out the great instructions offered by Josh Berkus and Joe Conway at http://www.powerpostgresql.com/PerfList/. The moral of this unreasonably verbose email is that you shouldn't abuse BenchmarkSQL and measure runs without making sure that, at least, quick/simple best practices have been applied to tuning the db's you are choosing to test. --Denis Lussier CTO http://www.enterprisedb.com > > > ------=_Part_15003_27600131.1154196555239 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
> systems could send me their bonnie + benchmarksql results!
 
I am one of the authors of BenchmarkSQL, it is similar to a DBT2.   But, its very easy to use (&/or abuse).   It's a multithreaded Java Swing client that can run the exact same benchmark (uses JDBC prepared statements) against Postgres/EnterpriseDB/Bizgres, MySQueeL, Horacle, Microsloth, etc, etc.  You can find BenchmarkSQL on pgFoundry and SourceForge.
 
As expected, Postgres is good on this benchmark and is getting better all the time.
 
If you run an EnterpriseDB install right out of the box versus a PG install right out of the box you'll notice that EnterpriseDB outperforms PG by better than 2x.    This does NOT mean that EnterpriseDB is 3x faster than Postgres...   EnterpriseDB is the same speed as Postgres.   We do something we call "Dynatune" at db startup time.  The algorithm is pretty simple in our current GA version and really only considers the amount of RAM, SHARED Memory, and machine usage pattern.  Manual tuning is required to really optimize performance....
 
For great insight into the basics of quickly tuning PostgreSQL for a reasonable starting point, check out the great instructions offered by Josh Berkus and Joe Conway at http://www.powerpostgresql.com/PerfList/.
 
The moral of this unreasonably verbose email is that you shouldn't abuse BenchmarkSQL and measure runs without making sure that, at least, quick/simple best practices have been applied to tuning the db's you are choosing to test.
 
--Denis Lussier
  CTO
>
------=_Part_15003_27600131.1154196555239--