From: Samed YILDIRIM <samed@reddoc.net>
To: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Huge swap usage
Date: Tue, 27 Feb 2018 15:00:27 +0300
Message-ID: <71691519732827@web2g.yandex.ru> (raw)
In-Reply-To: <2065222564.10906501.1519731937672.JavaMail.zimbra@tecnodata-srl.it>
References: <2065222564.10906501.1519731937672.JavaMail.zimbra@tecnodata-srl.it>
<div>Hi Mariano,</div><div> </div><div>Is the server dedicated for PostgreSQL or another applications run on it?</div><div> </div><div>Best regards.</div><div> </div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>27.02.2018, 14:46, "Mariano Di Girolamo" <m.digirolamo@tecnodata-srl.it>:</div><blockquote type="cite"><div><div style="font-family:arial,helvetica,sans-serif;font-size:12pt;color:#000000;"><div>Hi to all,</div><div>I have a virtual server centos <span style="background-color:#ffffff;color:#000000;display:inline !important;float:none;font-family:arial,helvetica,sans-serif;font-size:16px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;text-align:start;text-transform:none;white-space:normal;">7.3</span> with posgres <span style="background-color:#ffffff;color:#000000;display:inline !important;float:none;font-family:arial,helvetica,sans-serif;font-size:16px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;text-align:start;text-transform:none;white-space:normal;">9.5.7 and </span>I have a problem with huge swap usage.</div><div>In this moment I have 0 GB of free swap and 6,5 GB of RAM free.</div><div>My swappiness is set to 30 (as default) and the page size is 4 kB.</div><div>Is there someone that can help me to solve the problem?</div><div>Below my server configuration.</div><div> </div><div>Thanks</div><div> </div><div>---------------------</div><div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">Centos 7.3.1611</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">vCPU: 4</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">RAM: 16 GB</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">SWAP: 4GB</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">Postgresql: 9.5.7</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;"> </div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">## custom section of postgresql.conf ##</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">port = 5432</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">max_connections = 250<br />shared_buffers = 4GB<br />maintenance_work_mem = 512MB<br />checkpoint_timeout = 30min<br />escape_string_warning = off<br />standard_conforming_strings = off<br />work_mem = 32MB<br />effective_cache_size = 4GB<br />max_wal_senders = 10</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">log_parser_stats = on<br />log_planner_stats = on<br />log_executor_stats = on<br />log_statement_stats = on</div><div style="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;text-align:start;text-transform:none;white-space:normal;background-color:#ffffff;">log_autovacuum_min_duration = <span>216000000</span></div></div><div> </div><div> </div><div> </div><div> </div><div> </div><div><div style="font-family:tahoma,"new york",times,serif;font-size:13px;background-color:#fdfdfd;"><em><strong>Mariano Di Girolamo</strong></em><br />cell. <span style="color:#336699;cursor:pointer;"><a style="color:#336699;text-decoration:none;cursor:pointer;" href="callto:+39 329 0552286">+39 329 </a><span>0552286</span></span><br />tel. <span style="color:#336699;cursor:pointer;"><a style="color:#336699;text-decoration:none;cursor:pointer;" href="callto:+39 0735 7626263">+39 0735 7626263</a></span></div><div style="font-family:tahoma,"new york",times,serif;font-size:13px;background-color:#fdfdfd;">email: <span style="color:#336699;cursor:pointer;"><a style="color:#336699;text-decoration:none;cursor:pointer;" href="mailto:m.digirolamo@tecnodata-srl.it">m.digirolamo@tecnodata-srl.it </a></span></div><div style="font-family:tahoma,"new york",times,serif;font-size:13px;background-color:#fdfdfd;"><a title="www.tecnodata-srl.it" href="http://www.tecnodata-srl.it/"><img src="http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/tecnodata_logo.jpg"; /> </a> <img src="http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/cc_infinity_b_pic.png"; /></div><div style="font-family:tahoma,"new york",times,serif;font-size:13px;background-color:#fdfdfd;">Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (AP) Italy</div><div style="font-family:tahoma,"new york",times,serif;font-size:13px;background-color:#fdfdfd;"><div>tel. <span style="color:#336699;cursor:pointer;"><a style="color:#336699;text-decoration:none;cursor:pointer;" href="callto:+39 0735 7626261">+39 0735 7626261</a></span> - <span style="color:#336699;cursor:pointer;"><span style="cursor:pointer;"><a target="_blank" style="color:#336699;text-decoration:none;cursor:pointer;" href="http://www.tecnodata-srl.it/">www.tecnodata-srl.it</a></span></span></di... style="font-size:x-small;">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.</span></div></div></div></div></div></blockquote>
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: samed@reddoc.net, m.digirolamo@tecnodata-srl.it, pgsql-admin@lists.postgresql.org
Subject: Re: Huge swap usage
In-Reply-To: <71691519732827@web2g.yandex.ru>
* 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