Re: ERROR: too many dynamic shared memory segments

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(at)cisco(dot)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(dot)contu(at)gmail(dot)com>
> *Envoyé :* mercredi 11 septembre 2019 09:47
> *À :* pgsql-generallists.postgresql.org <
> pgsql-general(at)lists(dot)postgresql(dot)org>
> *Cc :* Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)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
>