AMD64 Faster?

[Vivek Khera]

On May 31, 2005, at 10:44 AM, Francisco Reyes wrote:

> On Tue, 31 May 2005, Vivek Khera wrote:
>
>
>> I'll confirm this with PostgreSQL.  I have a 1-year old Dell 2650  
>> with a 14-disk RAID array that cannot keep up with replication  
>> coming from a dual opteron with a 6 disk RAID array.
>>
>
> What are you using for replication?
>

slony-I (see /usr/ports/database/slony1)


> Compared to i386 how much memory is PostgreSQL and other apps using?
> On another thread I asked about memory usage was told that apps in  
> AMD64 mode seemed to be taking twice as much memory. I would be  
> very interesting in reading about PostgreSQL memory usage in  
> FreeBSD AMD64.
>

About the same.  The only thing really bigger in amd64 world is  
pointer size, and unless all you're building is a datastructure that  
has no data (ie just pointers) you're not gonna double your size...

>
>> For normal regular server usage, though, I don't see a need for  
>> opteron.
>>
>
> I wonder other data intensive apps (ie image/audio editing) how  
> they would do in Fbsd-AMD64. Also I wonder if it's an advantage  
> only when large amounts of data are moving or lots of data in  
> general. For example a busy news server or email server.
>

I think anything that is slinging lots of bits to a disk will  
benefit, or anything that moves a lot of memory.  The I/O on these  
puppies is just wicked fast.

Vivek Khera, Ph.D.
+1-301-869-4449 x806