From: Steve Wampler <swampler@noao.edu>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Alex Turner <armtuk@gmail.com>
Cc: Luke Lonergan <LLonergan@greenplum.com>
Cc: Adam Weisberg <Aweisberg@seiu1199.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (
Date: Wed, 16 Nov 2005 07:29:44 -0700
Message-ID: <437B4258.8050507@noao.edu> (raw)
In-Reply-To: <437B3B18.1040509@commandprompt.com>
References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com>
<33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com>
<437B3B18.1040509@commandprompt.com>
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?
--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: swampler@noao.edu, jd@commandprompt.com, armtuk@gmail.com, LLonergan@greenplum.com, Aweisberg@seiu1199.org
Subject: Re: Hardware/OS recommendations for large databases (
In-Reply-To: <437B4258.8050507@noao.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox