Date: Fri, 24 Mar 2006 08:57:49 -0600
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Dave Dutcher <dave@tridecap.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Problem with query, server totally unresponsive
Message-ID: <20060324145749.GR90527@pervasive.com>
References: <20060324102520.GS90527@pervasive.com>
	<000c01c64f51$cb71b590$8300a8c0@tridecap.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <000c01c64f51$cb71b590$8300a8c0@tridecap.com>
User-Agent: Mutt/1.5.11

On Fri, Mar 24, 2006 at 08:46:54AM -0600, Dave Dutcher wrote:
> > > The machine has 2x Intel dual core processors (3GHz) and 2 Gigs of
> ram.
> > 
> > Unless I missed some big news recently, no such CPU exists.
> > Hyperthreading is absolutely not the same as dual core, and many
> people
> > have found that it's best to disable hyperthreading on database
> servers.
> 
> Maybe I'm confused by the marketing, but I think those CPUs do exist.
> According to New Egg the Pentium D 830 and the Pentium D 930 both are
> dual core Pentiums that run at 3Ghz.  It also specifically says these
> processors don't support hyper threading, so I believe they really have
> two cores.   Maybe you are thinking he was talking about a 3Ghz Core
> Duo.

A quick google shows I'm just behind the times; Intel does have true
dual-core CPUs now.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461