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) < micka...@cisco.com> 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.co...@gmail.com> > *Envoyé :* mercredi 11 septembre 2019 09:47 > *À :* pgsql-generallists.postgresql.org < > pgsql-general@lists.postgresql.org> > *Cc :* Alessandro Aste <alessandro.a...@gtt.net> > *Objet :* ERROR: too many dynamic shared memory segments > > Hello, > 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 >
