Re: Total ram size study

[John R Pierce <pierce@xxxxxxxxxxxx>]

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