Hello,
We did not see any error in the logs, just that one.
Unfortunately we had problems installing updates in this machine and we are not installing updates since a few months.
Do you think that can be the issue? We are running Centos 7.
I will look into those parameters as well.
Thanks for your feedback
Il giorno mer 11 set 2019 alle ore 09:56 Mickael Franc (mickaelf) <mickaelf@xxxxxxxxx> ha scritto:
Hello,
Maybe a change needed in a kernel parameter such "kernel.shmmax" or "kernel.shmall" to allow by kernel to provide a huge shared-mem.
Did you see any other error in logs ? Have you upgrade your kernel since last two weeks ?
Best,
De : Nicola Contu <nicola.contu@xxxxxxxxx>
Envoyé : mercredi 11 septembre 2019 09:47
À : pgsql-generallists.postgresql.org <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Cc : Alessandro Aste <Alessandro.aste@xxxxxxx>
Objet : ERROR: too many dynamic shared memory segmentsHello,We are running postgres 11.5 and in the last two weeks we did :
- upgrade of postgres to 11.5 from 11.4- increased shared_buffer to 1/3 of the memory- increased effective_cache_size = 160GB from 120- increased checkpoint_completion_target = 0.9 from 0.7
- increased checkpoint_timeout = 1h
- increased work_mem = 2GB (this can be set up to 4GB) from 600MB
Since that, in the last two weeks we saw an increment of this error :
ERROR: too many dynamic shared memory segments
Is there any relation between these parameters or the pgsql 11.5 version?
Any help can be appreciated.
Thank you,Nicola
