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
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
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
Cybertec Schönig & Schönig GmbH
In response to
pgsql-performance by date
|Next:||From: Florian Weimer||Date: 2010-02-14 20:24:24|
|Subject: Re: Re: Faster CREATE DATABASE by delaying fsync|
|Previous:||From: Reydan Cankur||Date: 2010-02-14 18:46:03|
|Subject: Re: PostgreSQL on SMP Architectures|