Re: Problem with query, server totally unresponsive

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Dave Dutcher <dave(at)tridecap(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problem with query, server totally unresponsive
Date: 2006-03-24 14:57:49
Message-ID: 20060324145749.GR90527@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2006-03-24 15:02:15 Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Previous Message Dave Dutcher 2006-03-24 14:46:54 Re: Problem with query, server totally unresponsive