Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL on SMP Architectures

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: Reydan Cankur <reydan(dot)cankur(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL on SMP Architectures
Date: 2010-02-14 19:05:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Florian WeimerDate: 2010-02-14 20:24:24
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync
Previous:From: Reydan CankurDate: 2010-02-14 18:46:03
Subject: Re: PostgreSQL on SMP Architectures

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group