Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Total ram size study - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Total ram size study
Date
Msg-id 46bafa8d-9b45-c928-1eb1-e756dc968534@hogranch.com
Whole thread Raw
In response to [GENERAL] Total ram size study  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Not sure this should be asked here but...
Next
From: chiru r
Date:
Subject: Re: [GENERAL] pg_basebackup issue