pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: NUMA architecture and PostgreSQL
Date: Thu, 27 Nov 2008 10:20:04 +0100
Message-ID: <20081127092004.GC7442@easy2.in-chemnitz.de> (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 Wed, Nov 26, 2008 at 06:13:41PM -0700, Fabricio 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
>  
> Any suggestions?     Greetings...             Thanks...

I suppose this has nothing to do with PostgreSQL but needs some
operating system level tuning. Maybe there is a way to bind the postgres
processes to one node's CPUs... What operating system are you using?
I know that there are ways to bind processes to a CPU on Linux, I'm not
sure how to assign multiple processes to multiple CPUs. The Linux
scheduler should know about NUMA architectures though, there not that
new any more.

Tino.

-- 
"What we nourish flourishes." - "Was wir nähren erblüht."

www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de



view thread (6+ messages)  latest in thread

Message-ID: <20081127092004.GC7442@easy2.in-chemnitz.de>
Permalink:  ../20081127092004.GC7442@easy2.in-chemnitz.de/
Also on:    postgresql.org/message-id/20081127092004.GC7442@easy2.in-chemnitz.de

 · 

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: postgresql@tisc.de
  Subject: Re: NUMA architecture and PostgreSQL
  In-Reply-To: <20081127092004.GC7442@easy2.in-chemnitz.de>

* 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