Better use of memory

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>

Responses

Browse pgsql-novice by date

  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