Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id C9F862E002E for ; Sat, 24 May 2008 17:39:22 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 41722-04 for ; Sat, 24 May 2008 17:39:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.234]) by developer.postgresql.org (Postfix) with ESMTP id 9220D2E002D for ; Sat, 24 May 2008 17:39:17 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so1540224rvf.43 for ; Sat, 24 May 2008 13:39:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=lKyfycfIR0A/gZt0ZyIJqnomR84HRt+xBfk3HPq7vbs=; b=RzYlGqfhrdLd1wyxrrl9ae/VnBpDzE8h+cMhB+qwdJ83H9Mi9J79kndEo1t4npBJOuLRxzIIbj5WC6GeI8tjJEInBT44wQHyyQ1L51ZqIeF/UdDQ+/1QfwBCMa/KhVihnAf+vv93b9Ss9c9MXEMBGARrzFrvR6+lhviA7dIQ73A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ENSwBeCXLkMel9apMAbNOVi4ISuPhgQklVRt9zTs1bq3icRePNPNxl4v9GF4QHh5ejWM7uo+9MzV1pw8jSJF3rAjJhHzbwW+sapYZT9Cu5bv4I9P7VCJWZ+KyE9Fvg1aypLTw9E7gTOY2J5jlyJ0RMS+AXDR7Op0FAflmT8QfWA= Received: by 10.143.29.17 with SMTP id g17mr1250942wfj.239.1211661556023; Sat, 24 May 2008 13:39:16 -0700 (PDT) Received: by 10.142.242.21 with HTTP; Sat, 24 May 2008 13:39:15 -0700 (PDT) Message-ID: Date: Sat, 24 May 2008 13:39:15 -0700 From: "Jeffrey Baker" To: "Andrzej Zawadzki" Subject: Re: Quad Xeon or Quad Opteron? Cc: pgsql-performance@postgresql.org In-Reply-To: <48369F59.60902@wp.pl> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_56_11915816.1211661556024" References: <48369F59.60902@wp.pl> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/329 X-Sequence-Number: 30297 ------=_Part_56_11915816.1211661556024 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Fri, May 23, 2008 at 3:41 AM, Andrzej Zawadzki wrote: > Hello, > > We're planning new production server for PostgreSQL and I'm wondering > which processor (or even platform) will be better: Quad Xeon or Quad > Opteron (for example SUN now has a new offer Sun Fire X4440 x64). > > When I was buying my last database server, then SUN v40z was a really > very good choice (Intel's base server was slower). This v40z still works > pretty good but I need one more. > > AFAIK Intel made some changes in chipset but... is this better then AMD > HyperTransport and Direct Connect Architecture from database point of > view? How about L3 cache - is this important for performance? > Intel's chipset is still broken when using dual sockets and quad core processors. The problem manifests itself as excessive cache line bouncing. In my opinion the best bang/buck combo on the CPU side is the fastest dual-core Xeon CPUs you can find. You get excellent single-thread performance and you still have four processors, which was a fantasy for most people only 5 years ago. In addition you can put a ton of memory in the new Xeon machines. 64GB is completely practical. I still run several servers on Opterons but in my opinion they don't make sense right now unless you truly need the CPU parallelism. -jwb ------=_Part_56_11915816.1211661556024 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Fri, May 23, 2008 at 3:41 AM, Andrzej Zawadzki <zawadaa@wp.pl> wrote:
Hello,

 We're planning new production server for PostgreSQL and I'm wondering
which processor (or even platform) will be better: Quad Xeon or Quad
Opteron (for example SUN now has a new offer Sun Fire X4440 x64).

When I was buying my last database server, then SUN v40z was a really
very good choice (Intel's base server was slower). This v40z still works
pretty good but I need one more.

AFAIK Intel made some changes in chipset but... is this better then AMD
HyperTransport and Direct Connect Architecture from database point of
view? How about L3 cache - is this important for performance?

Intel's chipset is still broken when using dual sockets and quad core processors.  The problem manifests itself as excessive cache line bouncing.  In my opinion the best bang/buck combo on the CPU side is the fastest dual-core Xeon CPUs you can find.  You get excellent single-thread performance and you still have four processors, which was a fantasy for most people only 5 years ago.  In addition you can put a ton of memory in the new Xeon machines.  64GB is completely practical.

I still run several servers on Opterons but in my opinion they don't make sense right now unless you truly need the CPU parallelism.

-jwb

------=_Part_56_11915816.1211661556024--