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

Re: NUMA architecture and PostgreSQL

From: "Marko Kreen" <markokr(at)gmail(dot)com>
To: Fabricio <fabrixio1(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: NUMA architecture and PostgreSQL
Date: 2008-11-27 10:04:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 AroraDate: 2008-11-27 12:27:26
Subject: Re: PgAgent Job Scehduler is NOT running
Previous:From: Tino SchwarzeDate: 2008-11-27 09:20:04
Subject: Re: NUMA architecture and PostgreSQL

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