From: | "Jake O'brien Fagan" <jake(at)househappy(dot)org> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Better use of memory |
Date: | 2014-07-31 22:10:45 |
Message-ID: | CACjsCgQQuHD_PFRcRHrDip-q01b51bfPjbXc_QMCwM1rzBXfAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Howdy,
I am relatively new to Postgres, and I am trying to properly tune my
primary database. Looking at some server stats, my database does not seem
to utilize memory effectively. The server is 48GB VPS on Linode but never
uses more than 1500MBs of RAM. Can anyone give me some feedback on some of
my basic settings and possibly provide suggestions to better tune my
database?
Thank you,
Jahkobi
Server spec: RAM: 48GB CPU : 16x Cores Postgresql settings: Max
Connections: 120 Shared Buffers: 12288MB Work Mem: 144MB Maintenance Work
Mem: 6144MB Effective Cache Size: 36864MB Checkpoint Segments: 50
Checkpoint Timeout: 1h Checkpoint Completion Target: 0.5
------------------------------
Jake O'Brien Fagan
Ruby Engineer
househappy.org <http://www.househappy.org/>
Facebook <https://www.facebook.com/househappy.org> | Twitter
<https://twitter.com/househappy> | Instagram
<http://instagram.com/househappy>
From | Date | Subject | |
---|---|---|---|
Next Message | Jayadevan | 2014-08-01 04:07:35 | Re: Better use of memory |
Previous Message | Payal Singh | 2014-07-30 19:31:22 | Re: NOVICE |