Re: Hardware/OS recommendations for large databases ( - Mailing list pgsql-performance

From David Boreham
Subject Re: Hardware/OS recommendations for large databases (
Date
Msg-id 437B43AB.7050104@boreham.org
Whole thread Raw
In response to Re: Hardware/OS recommendations for large databases (  (Steve Wampler <swampler@noao.edu>)
Responses Re: Hardware/OS recommendations for large databases (
List 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.



pgsql-performance by date:

Previous
From: Steve Wampler
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: William Yu
Date:
Subject: Re: Hardware/OS recommendations for large databases (