Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C365F9FB620 for ; Thu, 31 May 2007 16:28:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 75314-03 for ; Thu, 31 May 2007 16:28:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id BCCE29FB3CB for ; Thu, 31 May 2007 16:28:20 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id s16so250242wxc for ; Thu, 31 May 2007 12:28:19 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=CJJgGdL4e7yH23YDomzKlr4pWgfbDugb+mc31DKMzKtPyJ0TuhH66DUDwBt4vpPeNm1SQ5hi63J/OzojraU2gsmbTcRRhERW4Wl6R4TeNHWA4eGQuE+Lk1THLSDbwDFQCrQdOe0a8/ctBuPIgd+9BDbxPG5OSRBRcxiRzF3Pu+k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=KxBy2RH4TmLJ6K4HMOl0I323exT51crs3rrWtvKCtzbb9pRl0wPnNnbgbNlrAFaHfI8fO2PrKj3xgIhKGH1003WPDI/K2wWR/i+sxqc+9kczxrjAa5XJBNNqXHzS9wdA/FsGwK6gTll97RtuwR0AlJ7tpNkfjaDq+PISPPL4DqI= Received: by 10.90.118.12 with SMTP id q12mr1116223agc.1180639699369; Thu, 31 May 2007 12:28:19 -0700 (PDT) Received: by 10.70.28.2 with HTTP; Thu, 31 May 2007 12:28:19 -0700 (PDT) Message-ID: <5482c80a0705311228o32ccaa19r116a71144fcaafd1@mail.gmail.com> Date: Thu, 31 May 2007 21:28:19 +0200 From: Dimitri To: "PostgreSQL Performance" Subject: Some info to share: db_STRESS Benchmark results MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200705/638 X-Sequence-Number: 25028 Folks, just wanted to share some benchmark results from one long performance study comparing MySQL, PostgreSQL and Oracle transactions throughput and engine scalability on T2000 and V890 (under Solaris). Oracle results are removed (of course :), but other are quite interesting... Findings are presented as it, following step by step learning and tuning curve :) So well, you may find: - http://dimitrik.free.fr/db_STRESS.html - Benchmark kit description - http://dimitrik.free.fr/db_STRESS_BMK_Part1.html -- first main part - http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html -- second part including ZFS specific tuning Tests were executed in Mar/Apr.2007 with latest v8.2.3 on that time. Due limited spare time I was able to publish results only now... Any comments are welcome! :) Best regards! -Dimitri