On Wed, Jun 12, 2019 at 4:25 PM Pavel Stehule <pavel.steh...@gmail.com> wrote:
> 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(); > Thanks, it works! > > in other session you can: > > show work_mem; > > Regards > > Pavel >
