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
