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