Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id CE9C4632F00 for ; Fri, 25 Jun 2010 15:53:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 69037-04 for ; Fri, 25 Jun 2010 18:53:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com [209.85.160.46]) by mail.postgresql.org (Postfix) with ESMTP id A2A21632ED1 for ; Fri, 25 Jun 2010 15:53:05 -0300 (ADT) Received: by pwj8 with SMTP id 8so2488644pwj.19 for ; Fri, 25 Jun 2010 11:53:03 -0700 (PDT) Received: by 10.142.195.11 with SMTP id s11mr1501368wff.18.1277491983718; Fri, 25 Jun 2010 11:53:03 -0700 (PDT) Received: from Craig-Jamess-MacBook-Pro.local (wsip-70-167-124-126.sd.sd.cox.net [70.167.124.126]) by mx.google.com with ESMTPS id l10sm512743rvh.21.2010.06.25.11.53.02 (version=SSLv3 cipher=RC4-MD5); Fri, 25 Jun 2010 11:53:03 -0700 (PDT) Message-ID: <4C24FB0D.4020701@emolecules.com> Date: Fri, 25 Jun 2010 11:53:01 -0700 From: Craig James User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: pgbench results on a new server References: <4BBCFB12.1010306@emolecules.com> <4BBD3A17.90209@emolecules.com> <4C23FD52.40508@emolecules.com> <23596.1277438692@sss.pgh.pa.us> <4C24B3BB.3070901@emolecules.com> <2286.1277477230@sss.pgh.pa.us> <4C24D679.7030701@emolecules.com> <6203.1277485291@sss.pgh.pa.us> In-Reply-To: <6203.1277485291@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/479 X-Sequence-Number: 39335 I've got a new server and want to make sure it's running well. Are these pretty decent numbers? 8 cores (2x4 Intel Nehalem 2 GHz) 12 GB memory 12 x 7200 SATA 500 GB disks 3WARE 9650SE-12ML RAID controller with BBU WAL on ext2, 2 disks: RAID1 500GB, blocksize=4096 Database on ext4, 8 disks: RAID10 2TB, stripe size 64K, blocksize=4096 Ubuntu 10.04 LTS (Lucid) Postgres 8.4.4 pgbench -i -s 100 -U test pgbench -c 5 -t 20000 -U test tps = 4903 pgbench -c 10 -t 10000 -U test tps = 4070 pgbench -c20 -t 5000 -U test tps = 5789 pgbench -c30 -t 3333 -U test tps = 6961 pgbench -c40 -t 2500 -U test tps = 2945 Thanks, Craig