Re: [ADMIN] NUMA architecture and PostgreSQL

2008-11-28 Thread lst_hoe02
Zitat von Fabricio <[EMAIL PROTECTED]>: 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 per

Re: [ADMIN] NUMA architecture and PostgreSQL

2008-11-27 Thread Fabricio
Hi Marko, thanks for your help... > 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. This paragr

Re: [ADMIN] NUMA architecture and PostgreSQL

2008-11-27 Thread Fabricio
> 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

Re: [ADMIN] NUMA architecture and PostgreSQL

2008-11-27 Thread Marko Kreen
On 11/27/08, Fabricio <[EMAIL PROTECTED]> 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

Re: [ADMIN] NUMA architecture and PostgreSQL

2008-11-27 Thread Tino Schwarze
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

[ADMIN] NUMA architecture and PostgreSQL

2008-11-26 Thread Fabricio
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 la