Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eqdha-0001Ds-Qc for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2018 11:45:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eqdhY-0005jq-Og for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2018 11:45:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eqdhY-0005jh-G5 for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2018 11:45:44 +0000 Received: from mta4.ilger.com ([77.81.238.17]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eqdhU-0005Ys-5f for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2018 11:45:44 +0000 Received: from localhost (localhost [127.0.0.1]) by mta4.ilger.com (Postfix) with ESMTP id EAB0A8396C for ; Tue, 27 Feb 2018 12:45:37 +0100 (CET) X-Virus-Scanned: amavisd-new at Received: from mta4.ilger.com ([127.0.0.1]) by localhost (mta4.ilger.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id Xi7kSkrbuyRQ for ; Tue, 27 Feb 2018 12:45:37 +0100 (CET) Received: from mta3.ilger.com (mta3.ilger.com [10.210.0.135]) by mta4.ilger.com (Postfix) with ESMTPS id D324A832F6 for ; Tue, 27 Feb 2018 12:45:37 +0100 (CET) Received: from localhost (localhost.localdomain [127.0.0.1]) by mta3.ilger.com (Postfix) with ESMTP id CEEA9604D6 for ; Tue, 27 Feb 2018 12:45:37 +0100 (CET) X-Virus-Scanned: amavisd-new at mta3.ilger.com Received: from mta3.ilger.com ([127.0.0.1]) by localhost (mta3.ilger.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id 18PF9NtxdXC8 for ; Tue, 27 Feb 2018 12:45:37 +0100 (CET) Received: from mailbox10.ilger.com (mailbox10.ilger.com [10.210.0.94]) by mta3.ilger.com (Postfix) with ESMTP id B86936017A for ; Tue, 27 Feb 2018 12:45:37 +0100 (CET) Date: Tue, 27 Feb 2018 12:45:37 +0100 (CET) From: Mariano Di Girolamo To: pgsql-admin@lists.postgresql.org Message-ID: <2065222564.10906501.1519731937672.JavaMail.zimbra@tecnodata-srl.it> Subject: Huge swap usage MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10906500_80829883.1519731937671" X-Mailer: Zimbra 8.6.0_GA_1211 (ZimbraWebClient - GC63 (Win)/8.6.0_GA_1211) Thread-Topic: Huge swap usage Thread-Index: PWulHtm2Ast3x1BXqBTdf3NsnZqvCw== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_10906500_80829883.1519731937671 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi to all,=20 I have a virtual server centos 7.3 with posgres 9.5.7 and I have a problem = with huge swap usage.=20 In this moment I have 0 GB of free swap and 6,5 GB of RAM free.=20 My swappiness is set to 30 (as default) and the page size is 4 kB.=20 Is there someone that can help me to solve the problem?=20 Below my server configuration.=20 Thanks=20 ---------------------=20 Centos 7.3.1611=20 vCPU: 4=20 RAM: 16 GB=20 SWAP: 4GB=20 Postgresql: 9.5.7=20 ## custom section of postgresql.conf ##=20 port =3D 5432=20 max_connections =3D 250=20 shared_buffers =3D 4GB=20 maintenance_work_mem =3D 512MB=20 checkpoint_timeout =3D 30min=20 escape_string_warning =3D off=20 standard_conforming_strings =3D off=20 work_mem =3D 32MB=20 effective_cache_size =3D 4GB=20 max_wal_senders =3D 10=20 log_parser_stats =3D on=20 log_planner_stats =3D on=20 log_executor_stats =3D on=20 log_statement_stats =3D on=20 log_autovacuum_min_duration =3D 216000000=20 Mariano Di Girolamo=20 cell. +39 329 0552286=20 tel. +39 0735 7626263=20 email: m.digirolamo@tecnodata-srl.it=20 Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (= AP) Italy=20 tel. +39 0735 7626261 - www.tecnodata-srl.it=20 Il contenuto di questa e-mail e degli eventuali allegati, =C3=A8 strettamen= te confidenziale, non producibile in giudizio e destinato alla/e persona/e = a cui =C3=A8 indirizzato. Se avete ricevuto per errore questa e-mail, Vi pr= eghiamo di segnalarcelo immediatamente e di cancellarla dal vostro computer= . E' fatto divieto di copiare e divulgare il contenuto di questa e-mail. Og= ni utilizzo abusivo delle informazioni qui contenute da parte di persone te= rze o comunque non indicate nella presente e-mail, potr=C3=A0 essere perseg= uito ai sensi di legge.=20 ------=_Part_10906500_80829883.1519731937671 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi to all,
I have a virtual serve= r centos 7.3 with posgres <= span style=3D"color: #000000; font-family: arial, helvetica, sans-serif; fo= nt-size: 16px; font-style: normal; font-variant-ligatures: normal; font-var= iant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; te= xt-align: start; text-indent: 0px; text-transform: none; white-space: norma= l; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background= -color: #ffffff; text-decoration-style: initial; text-decoration-color: ini= tial; display: inline !important; float: none;" data-mce-style=3D"color: #0= 00000; font-family: arial, helvetica, sans-serif; font-size: 16px; font-sty= le: normal; font-variant-ligatures: normal; font-variant-caps: normal; font= -weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-i= ndent: 0px; text-transform: none; white-space: normal; widows: 2; word-spac= ing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-d= ecoration-style: initial; text-decoration-color: initial; display: inline != important; float: none;">9.5.7 and I have a problem with huge s= wap usage.
In this moment I have 0 GB of free swap and 6,5 GB of = RAM free.
My swappiness is set to 30 (as default) and the page si= ze is 4 kB.
Is there someone that can help me to solve the proble= m?
Below my server configuration.

Thanks

-------= --------------
Centos 7.3.1611
vCPU: 4
RAM: 16 GB
Postgresql: 9.5.7

## custom section of postgresql.conf ##
<= div style=3D"color: #000000; font-family: arial, helvetica, sans-serif; fon= t-size: 16px; font-style: normal; font-variant-ligatures: normal; font-vari= ant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; tex= t-align: start; text-indent: 0px; text-transform: none; white-space: normal= ; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-= color: #ffffff; text-decoration-style: initial; text-decoration-color: init= ial;" data-mce-style=3D"color: #000000; font-family: arial, helvetica, sans= -serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal= ; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orph= ans: 2; text-align: start; text-indent: 0px; text-transform: none; white-sp= ace: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; = background-color: #ffffff; text-decoration-style: initial; text-decoration-= color: initial;">port =3D 5432
max_connections =3D 2= 50
shared_buffers =3D 4GB
maintenance_work_mem =3D 512MB
checkpoin= t_timeout =3D 30min
escape_string_warning =3D off
standard_conforming= _strings =3D off
work_mem =3D 32MB
effective_cache_size =3D 4GB
ma= x_wal_senders =3D 10
log_parser_stats =3D on
log_= planner_stats =3D on
log_executor_stats =3D on
log_statement_stats = =3D on
log_autovacuum_min_duration =3D 216000000=




=

Mariano Di Girolam= o
cell. +39 329 0552286
tel.&nb= sp;+39 0735 7626263
Tecnodata s.r.l. - Via Val T= iberina, 23A - 63074 San Benedetto del Tronto (AP) Italy
Il contenuto di questa e-mail e degli eventuali allegat= i, =C3=A8 strettamente confidenziale, non producibile in giudizio e destina= to alla/e persona/e a cui =C3=A8 indirizzato. Se avete ricevuto per errore = questa e-mail, Vi preghiamo di segnalarcelo immediatamente e di cancellarla= dal vostro computer. E' fatto divieto di copiare e divulgare il contenuto = di questa e-mail. Ogni utilizzo abusivo delle informazioni qui contenute da= parte di persone terze o comunque non indicate nella presente e-mail, potr= =C3=A0 essere perseguito ai sensi di legge.
<= /body> ------=_Part_10906500_80829883.1519731937671--