pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHuge swap usage
8+ messages / 6 participants
[nested] [flat]
* Huge swap usage
@ 2018-02-27 11:45 Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
0 siblings, 3 replies; 8+ messages in thread
From: Mariano Di Girolamo @ 2018-02-27 11:45 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Huge swap usage
@ 2018-02-27 12:00 Samed YILDIRIM <samed@reddoc.net>
parent: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
2 siblings, 2 replies; 8+ messages in thread
From: Samed YILDIRIM @ 2018-02-27 12:00 UTC (permalink / raw)
To: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
<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>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Huge swap usage
@ 2018-02-27 12:38 Oliver Jagape <oliver.jagape@concentrix.com>
parent: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
2 siblings, 0 replies; 8+ messages in thread
From: Oliver Jagape @ 2018-02-27 12:38 UTC (permalink / raw)
To: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Check this out and try to reconfigure your PostgreSQL.conf.
Thanks to the site owner.
http://pgtune.leopard.in.ua/
PgTune<http://pgtune.leopard.in.ua/;
pgtune.leopard.in.ua
PGTune calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration. It isn't a silver bullet for the optimization ...
Oliver
________________________________
From: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
Sent: Tuesday, February 27, 2018 7:45:37 PM
To: pgsql-admin@lists.postgresql.org
Subject: Huge swap usage
** EXTERNAL EMAIL **
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 <callto:+39%20329%200552286> 0552286
tel. +39 0735 7626263<callto:+39%200735%207626263>
email: m.digirolamo@tecnodata-srl.it <mailto:m.digirolamo@tecnodata-srl.it>
[http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/tecnodata_logo.jpg] <http://www.tecnodata-srl.it; [http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/cc_infinity_b_pic.png]
Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (AP) Italy
tel. +39 0735 7626261<callto:+39%200735%207626261> - www.tecnodata-srl.it<http://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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Huge swap usage
@ 2018-02-27 13:18 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Samed YILDIRIM <samed@reddoc.net>
1 sibling, 0 replies; 8+ messages in thread
From: Achilleas Mantzios @ 2018-02-27 13:18 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 <callto:+39%20329%200552286>0552286
>> tel. +39 0735 7626263 <callto:+39%200735%207626263>
>> email: m.digirolamo@tecnodata-srl.it <mailto:m.digirolamo@tecnodata-srl.it>
>> <http://www.tecnodata-srl.it/;
>> Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (AP) Italy
>> tel. +39 0735 7626261 <callto:+39%200735%207626261> - www.tecnodata-srl.it <http://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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Huge swap usage
@ 2018-02-27 13:50 Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
parent: Samed YILDIRIM <samed@reddoc.net>
1 sibling, 0 replies; 8+ messages in thread
From: Mariano Di Girolamo @ 2018-02-27 13:50 UTC (permalink / raw)
To: Samed YILDIRIM <samed@reddoc.net>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
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>
Inviato: Martedì, 27 febbraio 2018 13:00:27
Oggetto: Re: Huge swap usage
Hi Mariano,
Is the server dedicated for PostgreSQL or another applications run on it?
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
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.
--
Questo messaggio e' stato analizzato ed e' risultato non infetto.
This message was scanned and is believed to be clean.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Huge swap usage
@ 2018-02-28 08:17 Denis Corà <dcora@ibc.it>
parent: Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
2 siblings, 1 reply; 8+ messages in thread
From: Denis Corà @ 2018-02-28 08:17 UTC (permalink / raw)
To: m.digirolamo@tecnodata-srl.it; +Cc: pgsql-admin@lists.postgresql.org
hi Mariano,
use smem (epel repository) to find process use swap; on dedicate server,
i think you can set swappiness to 5
Denis
Il 27/02/2018 12:45, Mariano Di Girolamo ha scritto:
> 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 <callto:+39%20329%200552286>0552286
> tel. +39 0735 7626263 <callto:+39%200735%207626263>
> email: m.digirolamo@tecnodata-srl.it
> <mailto:m.digirolamo@tecnodata-srl.it>
> <http://www.tecnodata-srl.it;
> Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del
> Tronto (AP) Italy
> tel. +39 0735 7626261 <callto:+39%200735%207626261> -
> www.tecnodata-srl.it <http://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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Huge swap usage
@ 2018-02-28 12:15 Ricardo Martin Gomez <rimartingomez@hotmail.com>
parent: Denis Corà <dcora@ibc.it>
0 siblings, 1 reply; 8+ messages in thread
From: Ricardo Martin Gomez @ 2018-02-28 12:15 UTC (permalink / raw)
To: m.digirolamo@tecnodata-srl.it <m.digirolamo@tecnodata-srl.it>; Denis Corà <dcora@ibc.it>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Mariano.
You must reconfigure postgres.conf.
Never use the same value in swap and share buffers.
Best regards.
Obtener Outlook para Android<https://aka.ms/ghei36;
________________________________
From: Denis Corà <dcora@ibc.it>
Sent: Wednesday, February 28, 2018 5:17:05 AM
To: m.digirolamo@tecnodata-srl.it
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Huge swap usage
hi Mariano,
use smem (epel repository) to find process use swap; on dedicate server, i think you can set swappiness to 5
Denis
Il 27/02/2018 12:45, Mariano Di Girolamo ha scritto:
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 <callto:+39%20329%200552286> 0552286
tel. +39 0735 7626263<callto:+39%200735%207626263>
email: m.digirolamo@tecnodata-srl.it <mailto:m.digirolamo@tecnodata-srl.it>
[http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/tecnodata_logo.jpg] <http://www.tecnodata-srl.it; [http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/cc_infinity_b_pic.png]
Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (AP) Italy
tel. +39 0735 7626261<callto:+39%200735%207626261> - www.tecnodata-srl.it<http://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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Huge swap usage
@ 2018-02-28 12:19 Ricardo Martin Gomez <rimartingomez@hotmail.com>
parent: Ricardo Martin Gomez <rimartingomez@hotmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Ricardo Martin Gomez @ 2018-02-28 12:19 UTC (permalink / raw)
To: m.digirolamo@tecnodata-srl.it <m.digirolamo@tecnodata-srl.it>; Denis Corà <dcora@ibc.it>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
I'm sorry my mistake. The problem is effective caché size.
Obtener Outlook para Android<https://aka.ms/ghei36;
________________________________
From: Ricardo Martin Gomez <rimartingomez@hotmail.com>
Sent: Wednesday, February 28, 2018 9:15:31 AM
To: m.digirolamo@tecnodata-srl.it; Denis Corà
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Huge swap usage
Hi Mariano.
You must reconfigure postgres.conf.
Never use the same value in swap and share buffers.
Best regards.
Obtener Outlook para Android<https://aka.ms/ghei36;
________________________________
From: Denis Corà <dcora@ibc.it>
Sent: Wednesday, February 28, 2018 5:17:05 AM
To: m.digirolamo@tecnodata-srl.it
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Huge swap usage
hi Mariano,
use smem (epel repository) to find process use swap; on dedicate server, i think you can set swappiness to 5
Denis
Il 27/02/2018 12:45, Mariano Di Girolamo ha scritto:
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 <callto:+39%20329%200552286> 0552286
tel. +39 0735 7626263<callto:+39%200735%207626263>
email: m.digirolamo@tecnodata-srl.it <mailto:m.digirolamo@tecnodata-srl.it>
[http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/tecnodata_logo.jpg] <http://www.tecnodata-srl.it; [http://support.tecnodata-srl.it/tdinfinity24/dms/Logo_tecnodata/cc_infinity_b_pic.png]
Tecnodata s.r.l. - Via Val Tiberina, 23A - 63074 San Benedetto del Tronto (AP) Italy
tel. +39 0735 7626261<callto:+39%200735%207626261> - www.tecnodata-srl.it<http://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.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2018-02-28 12:19 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-02-27 11:45 Huge swap usage Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
2018-02-27 12:00 ` Samed YILDIRIM <samed@reddoc.net>
2018-02-27 13:18 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2018-02-27 13:50 ` Mariano Di Girolamo <m.digirolamo@tecnodata-srl.it>
2018-02-27 12:38 ` Oliver Jagape <oliver.jagape@concentrix.com>
2018-02-28 08:17 ` Denis Corà <dcora@ibc.it>
2018-02-28 12:15 ` Ricardo Martin Gomez <rimartingomez@hotmail.com>
2018-02-28 12:19 ` Ricardo Martin Gomez <rimartingomez@hotmail.com>
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