Re: scaling up postgres - Mailing list pgsql-performance

From Sven Geisler
Subject Re: scaling up postgres
Date
Msg-id 448D4E21.3010604@aeccom.com
Whole thread Raw
In response to Re: scaling up postgres  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Alex Stapleton
Date:
Subject: Re: scaling up postgres
Next
From: Ruben Rubio Rey
Date:
Subject: Posrgres speed problem