Re: Postgresql and Athlon64 ? - Mailing list pgsql-general

From William Yu
Subject Re: Postgresql and Athlon64 ?
Date
Msg-id ctpok7$1ing$1@news.hub.org
Whole thread Raw
In response to Re: Postgresql and Athlon64 ?  ("Guy Rouillier" <guyr@masergy.com>)
List pgsql-general
Guy Rouillier wrote:
> NTPT wrote:
>
>>Will I have some advantages, better performance etc using postgres
>>7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are
>>there asome benchmark available or someone  personal experience ?
>>
>>
>>Or should I stay in 32 bit platform  for a while ?
>
>
> PG 8 works fine on 64-bit Linux running on AMD64.  So I wouldn't stay on
> a 32-bit platform for that reason.  You are aware, of course, that
> Opteron is better equipped than Athlon64 for memory-intensive tasks:
> dual channel memory, (usually) more on-chip cache, etc.  Don't have any
> hard benchmark numbers, but AMD claims about a 15% general performance
> improvement switching from 32-bit to 64-bit.
>

Actually, A64s come in multiple flavors -- single channel, dual channel,
512KB L2, 1MB L2. The fastest A64 FXs are actually faster than their
corresponding Opteron cousins because not only do they have the same 2x
memory channel and 1MB cache -- but their unbuffered memory has lower
latency than registered memory that Opterons must use.

Of course, I wouldn't run a server without registered ECC memory so the
point is moot anyways. Plus you are limited to much less memory using
unbuffered memory.

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: cmin increments by 2 except in 7.4?
Next
From: Greg Stark
Date:
Subject: Re: Does indexing help >= as well as = for integer columns?