Adding more memory = hugh cpu load

From: alexandre - aldeia digital <adaldeia(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Adding more memory = hugh cpu load
Date: 2011-10-10 13:26:44
Message-ID: 4E92F294.9010405@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Yesterday, a customer increased the server memory from 16GB to 48GB.

Today, the load of the server hit 40 ~ 50 points.
With 16 GB, the load not surpasses 5 ~ 8 points.

The only parameter that I changed is effective_cache_size (from 14 GB to
40GB) and shared_buffers (from 1 GB to 5 GB). Setting the values back
does not take any effect.

This server use CentOS 5.5 (2.6.18-194.3.1.el5.centos.plus - X86_64).
Should I change some vm parameters to this specific kernel ?

Thanks for any help.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-10-10 13:51:08 Re: Adding more memory = hugh cpu load
Previous Message Leonardo Francalanci 2011-10-10 08:04:37 Re: : Performance Improvement Strategy