Re: ERROR: too many dynamic shared memory segments

[Nicola Contu <nicola.contu@xxxxxxxxx>]

If the error persist I will try to revert the work_mem.

Thanks a lot

Il giorno mer 11 set 2019 alle ore 10:10 Pavel Stehule <pavel.stehule@xxxxxxxxx> ha scritto:

Hi

st 11. 9. 2019 v 9:48 odesílatel Nicola Contu <nicola.contu@xxxxxxxxx> napsal:

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?

I expect it can be related to increasing work_mem - maybe parallel hash join was used

Regards

Pavel

Any help can be appreciated.

Thank you,

Nicola