Re: Adding more memory = hugh cpu load

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



alexandre - aldeia digital <adaldeia@xxxxxxxxx> wrote:
 
> From the point of view of the client, the question is simple:
> until the last friday (with 16 GB of RAM), the load average of
> server rarely surpasses 4. Nothing change in normal database use.
 
Really?  The application still performs as well or better, and it's
the load average they care about?  How odd.
 
If they were happy with performance before the RAM was added, why
did they add it?  If they weren't happy with performance, what led
them to believe that adding more RAM would help?  If there's a
performance problem, there's generally one bottleneck which is the
limit, with one set of symptoms.  When you remove that bottleneck
and things get faster, you may well have a new bottleneck with
different symptoms.  (These symptoms might include high load average
or CPU usage, for example.)  You then figure out what is causing
*that* bottleneck, and you can make things yet faster.
 
In this whole thread you have yet to give enough information to know
for sure whether there was or is any performance problem, or what
the actual bottleneck is.  I think you'll find that people happy to
help identify the problem and suggest solutions if you provide that
information.
 
-Kevin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux