Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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    work: 512-231-6117
vcard:       cell: 512-569-9461

In response to

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group