From: alexandre - aldeia digital <adaldeia@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Adding more memory = hugh cpu load
Date: Mon, 10 Oct 2011 10:26:44 -0300
Message-ID: <4E92F294.9010405@gmail.com> (raw)
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.
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-performance@postgresql.org
Cc: adaldeia@gmail.com
Subject: Re: Adding more memory = hugh cpu load
In-Reply-To: <4E92F294.9010405@gmail.com>
* 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