On 4/22/2017 8:27 AM, Melvin Davidson wrote:
*Has anyone ever done a study on performance increase via ram increase? I have a client on AWS with 8GB total ram (2GB shared_buffers), and I am curious if doubling the ram to 16GB (4GB shared_buffers) will result in minimizing query response time.*
entirely dependent on your data set and workload. if the working set fits in 2GB, then more memory likely won't do that much.
-- john r pierce, recycling bits in santa cruz
