Re: Large (8M) cache vs. dual-core CPUs - Mailing list pgsql-performance

From Ron Peacetree
Subject Re: Large (8M) cache vs. dual-core CPUs
Date
Msg-id 26758313.1146001394944.JavaMail.root@elwamui-mouette.atl.sa.earthlink.net
Whole thread Raw
In response to Large (8M) cache vs. dual-core CPUs  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
I've had intermittent "freeze and reboot" and, worse, just plain freeze problems with the Core Duo's I've been testing.
I have not been able to narrow it down so I do not know if it is a platform issue or a CPU issue.  It appears to be HW,
notSW, related since I have experienced the problem both under M$ and Linux 2.6 based OS's.  I have not tested the Core
Duo'sunder *BSD. 

Also, being that they are only 32b Core Duo's have limited utility for a present day DB server.

Power and space critical applications where 64b is not required may be a reasonable place for them... ...if the
present reliability problems I'm seeing go away.

Ron


-----Original Message-----
>From: David Boreham <david_list@boreham.org>
>Sent: Apr 25, 2006 5:15 PM
>To: pgsql-performance@postgresql.org
>Subject: Re: [PERFORM] Large (8M) cache vs. dual-core CPUs
>
>
>>My personal favorite pg platform at this time is one based on a 2 socket, dual core ready mainboard with 16 DIMM
slotscombined with dual core AMD Kx's. 
>>
>>
>Right. We've been buying Tyan bare-bones boxes like this.
>It's better to go with bare-bones than building boxes from bare metal
>because the cooling issues are addressed correctly.
>
>Note that if you need a large number of machines, then Intel
>Core Duo may give the best overall price/performance because
>they're cheaper to run and cool.
>

pgsql-performance by date:

Previous
From: "Junaili Lie"
Date:
Subject: slow deletes on pgsql 7.4
Next
From: "Junaili Lie"
Date:
Subject: Re: slow deletes on pgsql 7.4