X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8009D11F60AE for ; Tue, 25 Apr 2006 18:43:31 -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 40991-05 for ; Tue, 25 Apr 2006 18:43:17 -0300 (ADT) X-Greylist: delayed 00:33:21.061468 by SQLgrey- Received: from smtpauth04.mail.atl.earthlink.net (smtpauth04.mail.atl.earthlink.net [209.86.89.64]) by postgresql.org (Postfix) with ESMTP id CF2C011F6095 for ; Tue, 25 Apr 2006 18:43:14 -0300 (ADT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=rXGIRL6VGQAAK8eiwkoN7zSRgF6Blxnk1/DONpykqY7qH8mkGf95IIxR4Pw7iCal; h=Message-ID:Date:From:Reply-To:To:Subject:Mime-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:X-ELNK-Trace:X-Originating-IP; Received: from [209.86.224.41] (helo=elwamui-mouette.atl.sa.earthlink.net) by smtpauth04.mail.atl.earthlink.net with asmtp (Exim 4.34) id 1FYVJS-00048u-Ty; Tue, 25 Apr 2006 17:43:14 -0400 Received: from 70.22.235.105 by webmail.pas.earthlink.net with HTTP; Tue, 25 Apr 2006 17:43:14 -0400 Message-ID: <26758313.1146001394944.JavaMail.root@elwamui-mouette.atl.sa.earthlink.net> Date: Tue, 25 Apr 2006 17:43:14 -0400 (EDT) From: Ron Peacetree Reply-To: Ron Peacetree To: david_list@boreham.org, pgsql-performance@postgresql.org Subject: Re: Large (8M) cache vs. dual-core CPUs Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: EarthLink Zoo Mail 1.0 X-ELNK-Trace: acd68a6551193be5d780f4a490ca69563f9fea00a6dd62bcfdb6555dbcacabc698a35d9a5b709ae5350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 209.86.224.41 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/579 X-Sequence-Number: 18663 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, not SW, related since I have experienced the problem both under M$ and Linux 2.6 based OS's. I have not tested the Core Duo's under *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 >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 slots combined 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. >