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