pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: lst_hoe02@kwsoft.de
To: pgsql-admin@postgresql.org
Subject: Re: NUMA architecture and PostgreSQL
Date: Fri, 28 Nov 2008 11:32:10 +0100
Message-ID: <20081128113210.143342g6pazego8w@webmail.kwsoft.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>

Zitat von Fabricio <fabrixio1@hotmail.com>:

>
>
> Hi...
>
> 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

As far as i can see PostgreSQL is not able to support NUMA? With a  
little search i get to rellay interesting links according to the  
problem and a potential solution supported by Oracle (using huge  
pages). Unfortunately PostgreSQL seams not using "huge pages" until  
now??

http://oss.linbit.com/hugetlb/
http://kevinclosson.wordpress.com/kevin-closson-index/oracle-on-opteron-k8l-numa-etc/

Any comments on this from PostgreSQL developers?

Regards

Andreas




view thread (6+ messages)

Message-ID: <20081128113210.143342g6pazego8w@webmail.kwsoft.de>
Permalink:  ../20081128113210.143342g6pazego8w@webmail.kwsoft.de/
Also on:    postgresql.org/message-id/20081128113210.143342g6pazego8w@webmail.kwsoft.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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lst_hoe02@kwsoft.de
  Subject: Re: NUMA architecture and PostgreSQL
  In-Reply-To: <20081128113210.143342g6pazego8w@webmail.kwsoft.de>
  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> <20081128113210.143342g6pazego8w@webmail.kwsoft.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