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.steh...@gmail.com> ha scritto:
> Hi > > st 11. 9. 2019 v 9:48 odesÃlatel Nicola Contu <nicola.co...@gmail.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 >> >
