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/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
