pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Marko Kreen <markokr@gmail.com>
To: Fabricio <fabrixio1@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: NUMA architecture and PostgreSQL
Date: Thu, 27 Nov 2008 12:04:50 +0200
Message-ID: <e51f66da0811270204h50e6bb82l6f87a782bb685fb3@mail.gmail.com> (raw )
In-Reply-To: <BLU103-W22B9E9B2C9B9640E88A100FE050@phx.gbl >
References: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com >
<492D5C87.5090505@usit.uio.no >
<3a0028490811260700w6e8d9d86o24effbe0bea2bddb@mail.gmail.com >
<dcc563d10811260740m69f8969bt36be6ae675620dcb@mail.gmail.com >
<3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com >
<492DA95D.3010303@zeut.net >
<dcc563d10811261304g617b9806yf1208c4d5279ebee@mail.gmail.com >
<BLU103-W22B9E9B2C9B9640E88A100FE050@phx.gbl >
On 11/27/08, Fabricio <fabrixio1@hotmail.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
view thread (6+ messages) latest in thread
Message-ID: <e51f66da0811270204h50e6bb82l6f87a782bb685fb3@mail.gmail.com>
Permalink: ../e51f66da0811270204h50e6bb82l6f87a782bb685fb3@mail.gmail.com/
Also on: postgresql.org/message-id/e51f66da0811270204h50e6bb82l6f87a782bb685fb3@mail.gmail.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: markokr@gmail.com, fabrixio1@hotmail.com
Subject: Re: NUMA architecture and PostgreSQL
In-Reply-To: <e51f66da0811270204h50e6bb82l6f87a782bb685fb3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox