Re: ERROR: too many dynamic shared memory segments
| От | Nicola Contu |
|---|---|
| Тема | Re: ERROR: too many dynamic shared memory segments |
| Дата | |
| Msg-id | CAMTZZh3D50TmL7KET37rQ_GVyS2-VtOWhLByPmMAHO5bi_gtKQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | ERROR: too many dynamic shared memory segments (Nicola Contu <nicola.contu@gmail.com>) |
| Список | pgsql-general |
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@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.contu@gmail.com>
Envoyé : mercredi 11 septembre 2019 09:47
À : pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc : Alessandro Aste <Alessandro.aste@gtt.net>
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 600MBSince that, in the last two weeks we saw an increment of this error :ERROR: too many dynamic shared memory segmentsIs there any relation between these parameters or the pgsql 11.5 version?Any help can be appreciated.Thank you,Nicola
В списке pgsql-general по дате отправления: