Re: Hardware/OS recommendations for large databases (

From: David Boreham <david_list(at)boreham(dot)org>
To: Steve Wampler <swampler(at)noao(dot)edu>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Alex Turner <armtuk(at)gmail(dot)com>, Luke Lonergan <LLonergan(at)greenplum(dot)com>, Adam Weisberg <Aweisberg(at)seiu1199(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-16 14:35:23
Message-ID: 437B43AB.7050104@boreham.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Steve Wampler wrote:

>Joshua D. Drake wrote:
>
>
>>The reason you want the dual core cpus is that PostgreSQL can only
>>execute 1 query per cpu at a time,...
>>
>>
>
>Is that true? I knew that PG only used one cpu per query, but how
>does PG know how many CPUs there are to limit the number of queries?
>
>
>
He means only one query can be executing on each cpu at any particular
instant.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message William Yu 2005-11-16 14:37:48 Re: Hardware/OS recommendations for large databases (
Previous Message Steve Wampler 2005-11-16 14:29:44 Re: Hardware/OS recommendations for large databases (