Re: [PERFORM] PostgreSQL on SMP Architectures

2010-02-15 Thread Kevin Grittner
Reydan Cankur wrote: > 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. PostgreSQL itself won't use more cores than you have active connections, so

Re: [PERFORM] PostgreSQL on SMP Architectures

2010-02-14 Thread Boszormenyi Zoltan
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

Re: [PERFORM] PostgreSQL on SMP Architectures

2010-02-14 Thread Reydan Cankur
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. On Feb 14, 2010, at 8:25 PM, Scott Marlowe wrote: With all that info, your

Re: [PERFORM] PostgreSQL on SMP Architectures

2010-02-14 Thread Scott Marlowe
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. -- Sent via pgsql-perf

Re: [PERFORM] PostgreSQL on SMP Architectures

2010-02-14 Thread Arjen van der Meijden
Hi Reydan, PostgreSQL is unaware of the amount of cpu's and cores and doesn't really care about that. Its up to your OS to spread the work across the system. Be careful with what you test, normal PostgreSQL cannot spread a single query over multiple cores. But it will of course spread its fu

[PERFORM] PostgreSQL on SMP Architectures

2010-02-14 Thread Reydan Cankur
Hi, I have seen some work done about scaling PostgreSQL on SMP machines and see that PostgreSQL has been executed on several numbers of cores. I have some questions about scaling PostgreSQL on SMP architectures. System Details that I am running PostgreSQL-8.4.0: Server: HP Integrity Superdo