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: e51f66da0811270204h50e6bb82l6f87a782bb685fb3@mail.gmail.com (view raw or flat)
Thread:
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?
>
>  http://archives.postgresql.org/pgsql-general/2005-04/msg01187.php


You can use sched_setaffinity to select group of cpu-s for a process
and it's childs:

  http://www.kernel.org/doc/man-pages/online/pages/man2/sched_setaffinity.2.html

There is a bit higher level concept of cpusets too:

  http://www.kernel.org/doc/man-pages/online/pages/man7/cpuset.7.html

In both cases, you can either patch Postgres or write a launcher
that configures CPUs before executing postgres.

-- 
marko

In response to

Responses

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-2014 The PostgreSQL Global Development Group