Re: set parameter for all existing session

Hi

st 12. 6. 2019 v 9:58 odesílatel alex lock <alock303(at)gmail(dot)com> napsal:

> I check the “alter database, alter role " and "set " command, but none of
> them can set the parameters to all the existing sessions. do we have a
> way to do that? looks the "assign_hook" can be used to customize this, is
> it a right way to do that?
>
>
Maybe you miss to call pg_reload_conf();

example:

alter system set work_mem to '10MB';
select pg_reload_conf();

in other session you can:

show work_mem;

Regards

Pavel