Re: ERROR: too many dynamic shared memory segments

Hi

st 11. 9. 2019 v 9:48 odesílatel Nicola Contu <nicola(dot)contu(at)gmail(dot)com>
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
>