Обсуждение: Better use of memory
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
Are you have issues with response time? Which stats are telling you that memory is not being utilized effectively? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Better-use-of-memory-tp5813477p5813487.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
No issue with response times. At least I think not. Looking at NewRelic, the database generally responds in <10ms. My data is currently >150GB, and it seems odd the server's memory usage never tops 1500MB when many of my key settings are far greater than few GBs. Should I not worry?
On Thu, Jul 31, 2014 at 9:07 PM, Jayadevan <maymala.jayadevan@gmail.com> wrote:
Are you have issues with response time? Which stats are telling you that
memory is not being utilized effectively?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Better-use-of-memory-tp5813477p5813487.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
May be your active data set easily fits in the 1-2 GB range? This will tell you what is there in memory - http://www.postgresql.org/docs/9.3/static/pgbuffercache.html <http://www.postgresql.org/docs/9.3/static/pgbuffercache.html> I am sure you have done this, still...the settings have taken effect? Are you looking at the parameters in the file or you also tried show command - show shared_buffers; shared_buffers ---------------- 512MB (1 row) -- View this message in context: http://postgresql.1045698.n5.nabble.com/Better-use-of-memory-tp5813477p5813590.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.