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 1eqf9j-0007HI-Qa for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2018 13:18:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eqf9i-0004Bo-No for pgsql-admin@arkaria.postgresql.org; Tue, 27 Feb 2018 13:18:54 +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 1eqf9i-0004Be-Ev for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2018 13:18:54 +0000 Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=smadev.internal.net) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eqf9e-0007su-5S for pgsql-admin@lists.postgresql.org; Tue, 27 Feb 2018 13:18:53 +0000 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id w1RDIkan045756 for ; Tue, 27 Feb 2018 15:18:46 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: Huge swap usage To: pgsql-admin@lists.postgresql.org References: <2065222564.10906501.1519731937672.JavaMail.zimbra@tecnodata-srl.it> <71691519732827@web2g.yandex.ru> From: Achilleas Mantzios Message-ID: <92b8dd77-ffec-5699-371c-39aeffc9d14f@matrix.gatewaynet.com> Date: Tue, 27 Feb 2018 15:18:45 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: <71691519732827@web2g.yandex.ru> Content-Type: multipart/alternative; boundary="------------298B5F35BAB1398325526230" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------298B5F35BAB1398325526230 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 27/02/2018 14:00, Samed YILDIRIM wrote: > Hi Mariano, > Is the server dedicated for PostgreSQL or another applications run on it? I second that. htop then F6 to sort according to virtual mem or resident mem. Another application might have a memory leak somewhere. > Best regards. > İyi çalışmalar. > Samed YILDIRIM > 27.02.2018, 14:46, "Mariano Di Girolamo" : >> Hi to all, >> 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. >> 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 = 5432 >> max_connections = 250 >> shared_buffers = 4GB >> maintenance_work_mem = 512MB >> checkpoint_timeout = 30min >> escape_string_warning = off >> standard_conforming_strings = off >> work_mem = 32MB >> effective_cache_size = 4GB >> max_wal_senders = 10 >> log_parser_stats = on >> log_planner_stats = on >> log_executor_stats = on >> log_statement_stats = on >> log_autovacuum_min_duration = 216000000 >> /*Mariano Di Girolamo*/ >> cell. +39 329 0552286 >> tel. +39 0735 7626263 >> email: m.digirolamo@tecnodata-srl.it >> >> Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (AP) Italy >> tel. +39 0735 7626261  - www.tecnodata-srl.it >> Il contenuto di questa e-mail e degli eventuali allegati, è strettamente confidenziale, non producibile in giudizio e destinato alla/e persona/e a cui è 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à essere perseguito ai sensi di legge. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt --------------298B5F35BAB1398325526230 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
On 27/02/2018 14:00, Samed YILDIRIM wrote:
Hi Mariano,
 
Is the server dedicated for PostgreSQL or another applications run on it?

I second that. htop then F6 to sort according to virtual mem or resident mem. Another application might have a memory leak somewhere.

Best regards.
 
İyi çalışmalar.
Samed YILDIRIM
 
 
 
27.02.2018, 14:46, "Mariano Di Girolamo" <m.digirolamo@tecnodata-srl.it>:
Hi to all,
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.
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 = 5432
max_connections = 250
shared_buffers = 4GB
maintenance_work_mem = 512MB
checkpoint_timeout = 30min
escape_string_warning = off
standard_conforming_strings = off
work_mem = 32MB
effective_cache_size = 4GB
max_wal_senders = 10
log_parser_stats = on
log_planner_stats = on
log_executor_stats = on
log_statement_stats = on
log_autovacuum_min_duration = 216000000
 
 
 
 
 
Mariano Di Girolamo
cell. +39 329 0552286
tel. +39 0735 7626263
Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (AP) Italy
Il contenuto di questa e-mail e degli eventuali allegati, è strettamente confidenziale, non producibile in giudizio e destinato alla/e persona/e a cui è 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à essere perseguito ai sensi di legge.


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--------------298B5F35BAB1398325526230--