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