From: | Ricardo Martin Gomez <rimartingomez(at)hotmail(dot)com> |
---|---|
To: | "m(dot)digirolamo(at)tecnodata-srl(dot)it" <m(dot)digirolamo(at)tecnodata-srl(dot)it>, Denis Corà <dcora(at)ibc(dot)it> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Huge swap usage |
Date: | 2018-02-28 12:19:20 |
Message-ID: | SC1P152MB1344831A06AC1CE831A259D8A3C70@SC1P152MB1344.LAMP152.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm sorry my mistake. The problem is effective caché size.
Obtener Outlook para Android<https://aka.ms/ghei36>
________________________________
From: Ricardo Martin Gomez <rimartingomez(at)hotmail(dot)com>
Sent: Wednesday, February 28, 2018 9:15:31 AM
To: m(dot)digirolamo(at)tecnodata-srl(dot)it; Denis Corà
Cc: pgsql-admin(at)lists(dot)postgresql(dot)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(at)ibc(dot)it>
Sent: Wednesday, February 28, 2018 5:17:05 AM
To: m(dot)digirolamo(at)tecnodata-srl(dot)it
Cc: pgsql-admin(at)lists(dot)postgresql(dot)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(dot)digirolamo(at)tecnodata-srl(dot)it <mailto:m(dot)digirolamo(at)tecnodata-srl(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Nagy László Zsolt | 2018-02-28 14:57:30 | Reliable WAL file shipping over unreliable network |
Previous Message | Ricardo Martin Gomez | 2018-02-28 12:15:31 | Re: Huge swap usage |