From: Boszormenyi Zoltan <zb@cybertec.at>
To: Reydan Cankur <reydan.cankur@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL on SMP Architectures
Date: Sun, 14 Feb 2010 20:05:30 +0100
Message-ID: <4B78497A.7070606@cybertec.at> (raw)
In-Reply-To: <64CB629A-24B4-47D3-9E2C-72CE297B9FC8@gmail.com>
References: <4DA8D3EC-9868-4A6D-8806-F0534C55D2C6@gmail.com>
<dcc563d11002141025y14175213ucedfe6ffc08cb2ab@mail.gmail.com>
<64CB629A-24B4-47D3-9E2C-72CE297B9FC8@gmail.com>
Reydan Cankur írta:
> I want to do the second. I want to spread out the workload on all
> cores. But also I want to set the core number; for example first I
> want to spread out the workload to 32 cores then 64 cores and see the
> scalability.
You can use taskset(1) or schedtool(8) to set the CPU affinity
of the postmaster. New backends inherit the setting.
> On Feb 14, 2010, at 8:25 PM, Scott Marlowe wrote:
>
>> With all that info, your question is still kind of vague. Do you want
>> to be able to run a single query across all 64 cores? Or do you have
>> 1,000 users and you want them to be spread out on all cores.
>> PostgreSQL can do the second but has no native features to do the
>> first.
>
>
--
Bible has answers for everything. Proof:
"But let your communication be, Yea, yea; Nay, nay: for whatsoever is more
than these cometh of evil." (Matthew 5:37) - basics of digital technology.
"May your kingdom come" - superficial description of plate tectonics
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/
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: zb@cybertec.at, reydan.cankur@gmail.com, scott.marlowe@gmail.com
Subject: Re: PostgreSQL on SMP Architectures
In-Reply-To: <4B78497A.7070606@cybertec.at>
* 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