On 11/27/08, Fabricio <fabrixio1(at)hotmail(dot)com> wrote:
> I have an IBM server with NUMA architecture, two nodes with 4 CPU quad core and 64 GB of RAM each, and PostgrSQL 8.3.5.
> Is there any way to avoid the performance degradation when the load goes up and used the two nodes?
> I understand this performance degradation is due to the higher latency than a cpu access a remote memory that the local memory. But there are ways to improve this?
You can use sched_setaffinity to select group of cpu-s for a process
and it's childs:
There is a bit higher level concept of cpusets too:
In both cases, you can either patch Postgres or write a launcher
that configures CPUs before executing postgres.
In response to
pgsql-admin by date
|Next:||From: Vishal Arora||Date: 2008-11-27 12:27:26|
|Subject: Re: PgAgent Job Scehduler is NOT running|
|Previous:||From: Tino Schwarze||Date: 2008-11-27 09:20:04|
|Subject: Re: NUMA architecture and PostgreSQL|