From: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
To: pgsql-admin@lists.postgresql.org
Subject: Huge swap usage
Date: Tue, 27 Feb 2018 12:45:37 +0100 (CET)
Message-ID: <2065222564.10906501.1519731937672.JavaMail.zimbra@tecnodata-srl.it> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: m.digirolamo@tecnodata-srl.it, pgsql-admin@lists.postgresql.org
Subject: Re: Huge swap usage
In-Reply-To: <2065222564.10906501.1519731937672.JavaMail.zimbra@tecnodata-srl.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox