Hi st 12. 6. 2019 v 9:58 odesílatel alex lock <alock...@gmail.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
