Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average

From: FattahRozzaq <ssoorruu(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Igor Neyman <ineyman(at)perceptron(dot)com>, scott(dot)marlowe(at)gmail(dot)com, Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
Date: 2015-10-07 10:29:26
Message-ID: CAKnA-A3oN-ZFCb3Pz1VboG3CNuiFQwFUKGtSXZLnHC5mwGSQMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Response from you all are very precious.

@Merlin,
I'm misunderstood the question.
Yes, I didn't measure it. I only monitor RAM and CPU using htop (I also use
nmon for disk IO, iftop for the network utilization).
Did 1 connection need 1 core dedicatedly?
(I was having 40-80 connections in stable condition. And when the problem
happened the connections would be more than 150)

@Scott,
Just before the problem happened and when the problem happened, my server
didn't running out of IO/RAM/CPU.
The SSD IO total usage was 25-50% (I use nmon to monitor the disk IO)
The RAM total usage was 4-5GB of total 128GB (I monitor it using htop)
The CPU was 100% in 2 cores, 70% in 3 cores, the other 19 cores were under
5% (I monitor it using htop)
The network interface utilization was only 300-400 Mbps of total 1Gbps (I
monitor it using iftop)
So, maybe the 128GB RAM will never all be fully use by PostgreSQL?

I will test PostgreSQL with pg_bouncer in an identical logical (OS,
softwares, etc) condition and physical resource condition.

Respect,
FattahRozzaq

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2015-10-07 13:01:04 Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
Previous Message Scott Marlowe 2015-10-07 08:31:03 Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4