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

help / color / mirror / Atom feed
From: Fabricio <fabrixio1@hotmail.com>
To: postgresql@tisc.de
To: pgsql-admin@postgresql.org
Subject: Re: NUMA architecture and PostgreSQL
Date: Thu, 27 Nov 2008 09:45:47 -0700
Message-ID: <BLU103-W2633812FD33FDB6D970378FE050@phx.gbl> (raw)
In-Reply-To: <20081127092004.GC7442@easy2.in-chemnitz.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>
	<20081127092004.GC7442@easy2.in-chemnitz.de>


 > 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 am using Red Hat Enterprise 5.2, kernel  2.6.18-92.el5 x86_64
> 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.
 
something like this?
numactl --membind=1 su - postgres -c "/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data/"
 this bind memory to node 1 to use the shared memory on node 1 and cpus preferred node 1. With this the other processes and S.O by default will use the node 0?
 
thanks... 
_________________________________________________________________
Realiza búsquedas en Internet y llévate hasta ¡Un Auto! 
http://www.ganabuscando.com/Default.aspx=

view thread (6+ messages)  latest in thread

Message-ID: <BLU103-W2633812FD33FDB6D970378FE050@phx.gbl>
Permalink:  ../BLU103-W2633812FD33FDB6D970378FE050@phx.gbl/
Also on:    postgresql.org/message-id/BLU103-W2633812FD33FDB6D970378FE050@phx.gbl

 · 

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: fabrixio1@hotmail.com, postgresql@tisc.de
  Subject: Re: NUMA architecture and PostgreSQL
  In-Reply-To: <BLU103-W2633812FD33FDB6D970378FE050@phx.gbl>

* 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