Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TLLcR-0003Qs-51 for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 22:16:11 +0000 Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TLLcM-0001zb-UE for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 22:16:10 +0000 Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 8AD4DE00EC82; Mon, 8 Oct 2012 15:16:05 -0700 (PDT) Message-ID: <507350A5.2080503@pinpointresearch.com> Date: Mon, 08 Oct 2012 15:16:05 -0700 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120912 Thunderbird/15.0.1 MIME-Version: 1.0 To: Craig James CC: pgsql-performance@postgresql.org Subject: Re: Two identical systems, radically different performance References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------040203060006060904010803" X-Pg-Spam-Score: -4.0 (----) X-Archive-Number: 201210/62 X-Sequence-Number: 48021 This is a multi-part message in MIME format. --------------040203060006060904010803 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 10/08/2012 02:45 PM, Craig James wrote: > This is driving me crazy. A new server, virtually identical to an old > one, has 50% of the performance with pgbench. I've checked everything > I can think of. > > The setups (call the servers "old" and "new"): > > old: 2 x 4-core Intel Xeon E5620 > new: 4 x 4-core Intel Xeon E5606 > > both: > > memory: 12 GB DDR EC > Disks: 12x500GB disks (Western Digital 7200RPM SATA) > 2 disks, RAID1: OS (ext4) and postgres xlog (ext2) > 8 disks, RAID10: $PGDATA Exact same model of disk, same on-board cache, same RAID-card RAM size, same RAID strip-size, etc.?? Cheers, Steve --------------040203060006060904010803 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

On 10/08/2012 02:45 PM, Craig James wrote:

This is driving me crazy. A new server, virtually identical to an old one, has 50% of the performance with pgbench. I've checked everything I can think of.

The setups (call the servers "old" and "new"):

old: 2 x 4-core Intel Xeon E5620
new: 4 x 4-core Intel Xeon E5606

both:

memory: 12 GB DDR EC
Disks: 12x500GB disks (Western Digital 7200RPM SATA)
2 disks, RAID1: OS (ext4) and postgres xlog (ext2)
8 disks, RAID10: $PGDATA

Exact same model of disk, same on-board cache, same RAID-card RAM size, same RAID strip-size, etc.??

Cheers,
Steve

--------------040203060006060904010803--