Re: ALTER SESSION

2019-02-01 Thread Kyotaro HORIGUCHI
Hello. At Fri, 1 Feb 2019 06:31:40 +, "Tsunakawa, Takayuki" wrote in <0A3221C70F24FB45833433255569204D1FB927B1@G01JPEXMBYT05> > Thanks for a cool feature with nice UI. Can I expect it to work for > background processes? For troubleshooting, I wanted to investigate how > autovacuum launc

RE: ALTER SESSION

2019-01-31 Thread Tsunakawa, Takayuki
Thanks for a cool feature with nice UI. Can I expect it to work for background processes? For troubleshooting, I wanted to investigate how autovacuum launcher/worker behaves by having them emit DEBUG messages. (My comments follow) From: Kyotaro HORIGUCHI [mailto:horiguchi.kyot...@lab.ntt.co.

Re: ALTER SESSION

2019-01-29 Thread Kyotaro HORIGUCHI
At Tue, 29 Jan 2019 21:46:28 -0500, Stephen Frost wrote in <20190130024628.ge5...@tamriel.snowman.net> > Greetings, > > * Andres Freund (and...@anarazel.de) wrote: > > On 2019-01-29 21:09:22 -0500, Stephen Frost wrote: > > > * Andres Freund (and...@anarazel.de) wrote: > > > > On 2019-01-29 20:52

Re: ALTER SESSION

2019-01-29 Thread Stephen Frost
Greetings, * Andres Freund (and...@anarazel.de) wrote: > On 2019-01-29 21:09:22 -0500, Stephen Frost wrote: > > * Andres Freund (and...@anarazel.de) wrote: > > > On 2019-01-29 20:52:08 -0500, Stephen Frost wrote: > > > > * Andres Freund (and...@anarazel.de) wrote: > > > > > Leaving the desirabilit

Re: ALTER SESSION

2019-01-29 Thread Andres Freund
On 2019-01-29 21:09:22 -0500, Stephen Frost wrote: > Greetings, > > * Andres Freund (and...@anarazel.de) wrote: > > On 2019-01-29 20:52:08 -0500, Stephen Frost wrote: > > > * Andres Freund (and...@anarazel.de) wrote: > > > > Leaving the desirability of the feature aside, isn't this racy as hell? >

Re: ALTER SESSION

2019-01-29 Thread Stephen Frost
Greetings, * Andres Freund (and...@anarazel.de) wrote: > On 2019-01-29 20:52:08 -0500, Stephen Frost wrote: > > * Andres Freund (and...@anarazel.de) wrote: > > > Leaving the desirability of the feature aside, isn't this racy as hell? > > > I.e. it seems entirely possible that backends stop/start b

Re: ALTER SESSION

2019-01-29 Thread Andres Freund
On 2019-01-29 20:52:08 -0500, Stephen Frost wrote: > * Andres Freund (and...@anarazel.de) wrote: > > Leaving the desirability of the feature aside, isn't this racy as hell? > > I.e. it seems entirely possible that backends stop/start between > > determining the PID, and the ALTER SESSION creating t

Re: ALTER SESSION

2019-01-29 Thread Stephen Frost
Greetings, * Andres Freund (and...@anarazel.de) wrote: > On 2019-01-29 20:32:54 +0900, Kyotaro HORIGUCHI wrote: > > Hello. > > > > https://www.postgresql.org/message-id/20190128.133143.115303042.horiguchi.kyot...@lab.ntt.co.jp > > > > > C. Provide session-specific GUC variable (that overides the

Re: ALTER SESSION

2019-01-29 Thread Andres Freund
Hi, On 2019-01-29 20:32:54 +0900, Kyotaro HORIGUCHI wrote: > Hello. > > https://www.postgresql.org/message-id/20190128.133143.115303042.horiguchi.kyot...@lab.ntt.co.jp > > > C. Provide session-specific GUC variable (that overides the global one) > >- Add new configuration file "postgresql.co

Re: ALTER SESSION

2019-01-29 Thread Kyotaro HORIGUCHI
At Tue, 29 Jan 2019 20:32:54 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI wrote in <20190129.203254.115361483.horiguchi.kyot...@lab.ntt.co.jp> > Hello. > > https://www.postgresql.org/message-id/20190128.133143.115303042.horiguchi.kyot...@lab.ntt.co.jp > > > C. Provide session-specific GUC va