Обсуждение: Memory and Swap
PostgreSQL 9.5.2
Linux Red Hat
I have 10 G of memory. Nagios is saying I have 2 G used and 8 G free.
Yet my swap is at 1 G.
1) Why is that?
2) Over that past week it has climbed from almost nothing to 1 G. It is a steady climb. No big jump.
Thanks,
Lance
-------- Original message --------
From: "Campbell, Lance" <lance@illinois.edu>
Date: 05/10/2016 3:25 PM (GMT-06:00)
To: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: [ADMIN] Memory and Swap
PostgreSQL 9.5.2
Linux Red Hat
I have 10 G of memory. Nagios is saying I have 2 G used and 8 G free.
Yet my swap is at 1 G.
1) Why is that?
2) Over that past week it has climbed from almost nothing to 1 G. It is a steady climb. No big jump.
Thanks,
Lance
Austin, TX 78757
www.journyx.com
Linux tends to swap out to early with the default settings of swappiness, try to decrease it to 10 or 1 https://en.wikipedia.org/wiki/Swappiness Marco Am 10.05.2016 um 22:23 schrieb Campbell, Lance: > PostgreSQL 9.5.2 > > Linux Red Hat > > I have 10 G of memory. Nagios is saying I have 2 G used and 8 G free. > > Yet my swap is at 1 G. > > 1)Why is that? > > 2)Over that past week it has climbed from almost nothing to 1 G. It is > a steady climb. No big jump. > > Thanks, > > Lance >
Marco and Scott, Thanks for your answers. The Swappiness web link was great. Lance -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Marco Nietz Sent: Wednesday, May 11, 2016 12:37 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Memory and Swap Linux tends to swap out to early with the default settings of swappiness, try to decrease it to 10 or 1 https://en.wikipedia.org/wiki/Swappiness Marco Am 10.05.2016 um 22:23 schrieb Campbell, Lance: > PostgreSQL 9.5.2 > > Linux Red Hat > > I have 10 G of memory. Nagios is saying I have 2 G used and 8 G free. > > Yet my swap is at 1 G. > > 1)Why is that? > > 2)Over that past week it has climbed from almost nothing to 1 G. It > is a steady climb. No big jump. > > Thanks, > > Lance > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
PostgreSQL 9.5.2
Linux Red Hat
I have 10 G of memory. Nagios is saying I have 2 G used and 8 G free.
Yet my swap is at 1 G.
1) Why is that?
2) Over that past week it has climbed from almost nothing to 1 G. It is a steady climb. No big jump.
Thanks for the reply.
What are the values that can appear in the column SI and SO? Are those disk blocks? Also how high would those numbers possibly get in those two columns before I should be concerned. I am noticing two digit number like 84. Every once in a while it will spike to something like 814.
Lance
From: Fernando Hevia [mailto:fhevia@gmail.com]
Sent: Wednesday, May 11, 2016 3:14 PM
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Memory and Swap
I wouldn't worry about the system using swap while there is plenty of free RAM available. As others have stated, it is a rather common situation. The kernel might decide on moving some seldom accessed memory pages to swap in order to make RAM available for future demand. But when RAM starts running low, do keep and eye on how many bytes are actually being swapped. You can use vmstat to show the amount of bytes being swapped in/out of the system.
I.e: vmstat output of a system with no swapping taking place and marginal swap usage:
~# vmstat 5
procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
2 0 28052 363992 156736 1251116 0 0 6 15 1 7 2 1 97 0
0 0 28052 363964 156736 1251128 0 0 0 13 759 283 2 2 96 0
0 0 28052 371132 156736 1251132 0 0 0 5 348 287 1 1 98 0
Any value > 0 means the system is actually reading from or writing to swap, at the same time you should notice a severe downgrade of the system's performance.
On Tue, May 10, 2016 at 5:23 PM, Campbell, Lance <lance@illinois.edu> wrote:
PostgreSQL 9.5.2
Linux Red Hat
I have 10 G of memory. Nagios is saying I have 2 G used and 8 G free.
Yet my swap is at 1 G.
1) Why is that?
2) Over that past week it has climbed from almost nothing to 1 G. It is a steady climb. No big jump.
Lance Campbell wrote: > What are the values that can appear in the column SI and SO? Are those disk blocks? Also how high > would those numbers possibly get in those two columns before I should be concerned. I am noticing two > digit number like 84. Every once in a while it will spike to something like 814. The unit should be KB/s, check your vmstat man page. Occasional "so" shouldn't be a problem, but if "si" is greater than 0 regularly, you are probably memory constrained. Yours, Laurenz Albe