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 91E539FA430 for ; Mon, 12 Jun 2006 08:21:13 -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 39541-05 for ; Mon, 12 Jun 2006 08:21:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.aeccom.com (port-83-236-156-26.static.qsc.de [83.236.156.26]) by postgresql.org (Postfix) with ESMTP id 0B8229FA42B for ; Mon, 12 Jun 2006 08:21:08 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.aeccom.com (Postfix) with ESMTP id F169C1CEC3; Mon, 12 Jun 2006 13:21:06 +0200 (CEST) Received: from mail.aeccom.com ([127.0.0.1]) by localhost (gate6.aeccom.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 06776-03-4; Mon, 12 Jun 2006 13:21:06 +0200 (CEST) Received: from [192.168.2.247] (dhcp-07.core.aeccom.com [192.168.2.247]) by mail.aeccom.com (Postfix) with ESMTP id 0D89C1CEBC; Mon, 12 Jun 2006 13:21:06 +0200 (CEST) Message-ID: <448D4E21.3010604@aeccom.com> Date: Mon, 12 Jun 2006 13:21:05 +0200 From: Sven Geisler Organization: AEC/communications GmbH User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: "Joshua D. Drake" CC: mario.splivalo@mobart.hr, "Steinar H. Gunderson" , pgsql-performance@postgresql.org Subject: Re: scaling up postgres References: <200606030931.k539V38Y007877@smtp2.planet.net.tn> <20060603094355.GA23297@uio.no> <1150062140.23423.0.camel@localhost.localdomain> <448CA592.4040506@commandprompt.com> In-Reply-To: <448CA592.4040506@commandprompt.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at aeccom.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/129 X-Sequence-Number: 19486 Hi all, Joshua D. Drake schrieb: > Mario Splivalo wrote: >> Could you point out to some more detailed reading on why Xeons are >> poorer choice than Opterons when used with PostgreSQL? > > It isn't just PostgreSQL. It is any database. Opterons can move memory > and whole lot faster then Xeons. Yes. You can run good old memtest86 and you see the difference. Here my numbers with memtest86 (blocksize 128 MB). HP DL580 G3 (4-way XEON MP - DDR RAM) => 670 MByte/sec FSC RX600 S2 (4-way XEOM MP DC - DDR2-400 PC2-3200) => 1300 MByte/sec HP DL585 (4-way Opteron DDR2-400 PC2-3200) => 1500 MByte/sec I used memxfer5b.cpp. Cheers Sven.