Re: Adding more memory = hugh cpu load - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Adding more memory = hugh cpu load
Date
Msg-id 4E9314A50200002500041D12@gw.wicourts.gov
Whole thread Raw
In response to Re: Adding more memory = hugh cpu load  (alexandre - aldeia digital <adaldeia@gmail.com>)
Responses Re: Adding more memory = hugh cpu load
List pgsql-performance
alexandre - aldeia digital <adaldeia@gmail.com> wrote:

> I came to the list to see if anyone else has experienced the same
> problem

A high load average or low idle CPU isn't a problem, it's a
potentially useful bit of information in diagnosing a problem.  I
was hoping to hear what the actual problem was, since I've had a few
problems in high RAM situations, but the solutions depend on what
the actual problems are.  I don't suppose you saw periods where
queries which normally run very quickly (say in a millisecond or
less) were suddenly taking tens of seconds to run -- "stalling" and
then returning to normal?  Because if I knew you were having a
problem like *that* I might have been able to help.  Same for other
set of symptoms; it's just the suggestions would have been
different.  And the suggestions would have depended on what your
system looked like besides the RAM.

If you're satisfied with how things are running with less RAM,
though, there's no need.

-Kevin

pgsql-performance by date:

Previous
From: alexandre - aldeia digital
Date:
Subject: Re: Adding more memory = hugh cpu load
Next
From: Samuel Gendler
Date:
Subject: Re: Adding more memory = hugh cpu load