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 1eqfep-00012H-Kp for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2018 13:51:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eqfen-0008Dz-8x for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2018 13:51:01 +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 1eqfen-0008Dq-07 for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2018 13:51:01 +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 1eqfef-0000F9-3F for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2018 13:51:00 +0000 Received: from localhost (localhost [127.0.0.1]) by mta4.ilger.com (Postfix) with ESMTP id DC6BE83A57; Tue, 27 Feb 2018 14:50:50 +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 eBGRq8bgyxh2; Tue, 27 Feb 2018 14:50:50 +0100 (CET) Received: from mta3.ilger.com (mta3.ilger.com [10.210.0.135]) by mta4.ilger.com (Postfix) with ESMTPS id C3B0C83A39; Tue, 27 Feb 2018 14:50:50 +0100 (CET) Received: from localhost (localhost.localdomain [127.0.0.1]) by mta3.ilger.com (Postfix) with ESMTP id C056961233; Tue, 27 Feb 2018 14:50:50 +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 UlPyp_1lJgnX; Tue, 27 Feb 2018 14:50:50 +0100 (CET) Received: from mailbox10.ilger.com (mailbox10.ilger.com [10.210.0.94]) by mta3.ilger.com (Postfix) with ESMTP id A8BFC6017A; Tue, 27 Feb 2018 14:50:50 +0100 (CET) Date: Tue, 27 Feb 2018 14:50:50 +0100 (CET) From: Mariano Di Girolamo To: Samed YILDIRIM Cc: pgsql-admin Message-ID: <1670306702.11014658.1519739450578.JavaMail.zimbra@tecnodata-srl.it> In-Reply-To: <71691519732827@web2g.yandex.ru> References: <2065222564.10906501.1519731937672.JavaMail.zimbra@tecnodata-srl.it> <71691519732827@web2g.yandex.ru> Subject: Re: Huge swap usage MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11014657_1504605919.1519739450577" X-Mailer: Zimbra 8.6.0_GA_1211 (ZimbraWebClient - GC63 (Win)/8.6.0_GA_1211) Thread-Topic: Huge swap usage Thread-Index: szd3AzGtqCEJTRa7i7OX379ghUZ5YA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_11014657_1504605919.1519739450577 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Samed,=20 the server is dedicated for PostgreSQL.=20 Thanks=20 Da: "Samed YILDIRIM" =20 A: "m digirolamo" , "pgsql-admin" =20 Inviato: Marted=C3=AC, 27 febbraio 2018 13:00:27=20 Oggetto: Re: Huge swap usage=20 Hi Mariano,=20 Is the server dedicated for PostgreSQL or another applications run on it?= =20 Best regards.=20 =C4=B0yi =C3=A7al=C4=B1=C5=9Fmalar.=20 Samed YILDIRIM=20 27.02.2018, 14:46, "Mariano Di Girolamo" := =20 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 --=20 Questo messaggio e' stato analizzato ed e' risultato non infetto.=20 This message was scanned and is believed to be clean.=20 ------=_Part_11014657_1504605919.1519739450577 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi Samed,
the server is dedicated = for PostgreSQL.

Thanks

Da: "Samed YILDIRIM" <= samed@reddoc.net>
A: "m digirolamo" <m.digirolamo@tecnodata= -srl.it>, "pgsql-admin" <pgsql-admin@lists.postgresql.org>
I= nviato: Marted=C3=AC, 27 febbraio 2018 13:00:27
Oggetto: Re: = Huge swap usage

Hi M= ariano,
 
Is the server dedicated for PostgreSQL o= r another applications run on it?
 
Best regards.<= /div>
 
=C4=B0yi =C3=A7al=C4=B1=C5=9Fmalar.
Sa= med YILDIRIM
 
 
 
2= 7.02.2018, 14:46, "Mariano Di Girolamo" <m.digirolamo@tecnodata-srl.it&g= t;:
Hi to al= l,
I have a virtual server centos 7.3 with posgres 9.5.7 and I have a problem with huge swap usage.=
In this moment I have 0 GB of free swap and 6,5 GB of RAM free.<= /div>
My swappiness is set to 30 (as default) and the page size is 4 kB= .
Is there someone that can help me to solve the problem?
Below my server configuration.
 
Thanks
 
---------------------
Centos 7.3.1611
vCPU: = 4
RAM: 16 GB
SWAP: 4GB
Postgresql:= 9.5.7
 
## custom section of postgresql.conf ##
port =3D 5432
max_c= onnections =3D 250
shared_buffers =3D 4GB
maintenance_work_mem =3D 51= 2MB
checkpoint_timeout =3D 30min
escape_string_warning =3D off
sta= ndard_conforming_strings =3D off
work_mem =3D 32MB
effective_cache_si= ze =3D 4GB
max_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
&nbs= p;
 
 
 
 
Mariano Di Girolamo
cell. +39 329 = 0552286
tel. +39 0735 7626263
email: 
Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tront= o (AP) Italy
Il contenuto di questa e-mail e degli eventual= i allegati, =C3=A8 strettamente confidenziale, non producibile in giudizio = e destinato alla/e persona/e a cui =C3=A8 indirizzato. Se avete ricevuto pe= r errore questa e-mail, Vi preghiamo di segnalarcelo immediatamente e di ca= ncellarla dal vostro computer. E' fatto divieto di copiare e divulgare il c= ontenuto di questa e-mail. Ogni utilizzo abusivo delle informazioni qui con= tenute da parte di persone terze o comunque non indicate nella presente e-m= ail, potr=C3=A0 essere perseguito ai sensi di legge.

--
Questo messaggio e' stato= analizzato ed e' risultato non infetto.
This message was scanned and is= believed to be clean.


------=_Part_11014657_1504605919.1519739450577--