Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE

2017-12-07 Thread Tom Lane
=?UTF-8?Q?Ulf_Lohbr=C3=BCgge?= writes: > 2017-12-07 17:01 GMT+01:00 Tom Lane : >> It looks like the first time such a question is asked within a session, >> we build and cache a list of all the roles the session user is a member >> of (directly or indirectly). That's what's taking the time here -

Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE

2017-12-07 Thread Ulf Lohbrügge
2017-12-07 17:01 GMT+01:00 Tom Lane : > =?UTF-8?Q?Ulf_Lohbr=C3=BCgge?= writes: > > I could reproduce part of the things I described earlier in this thread. > A > > guy named Andriy Senyshyn mailed me after reading this thread here (he > > could somehow not join the mailing list) and observed a di

Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE

2017-12-07 Thread Tom Lane
=?UTF-8?Q?Ulf_Lohbr=C3=BCgge?= writes: > I could reproduce part of the things I described earlier in this thread. A > guy named Andriy Senyshyn mailed me after reading this thread here (he > could somehow not join the mailing list) and observed a difference when > issuing "SET ROLE" as user postgr

Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE

2017-12-07 Thread Ulf Lohbrügge
I could reproduce part of the things I described earlier in this thread. A guy named Andriy Senyshyn mailed me after reading this thread here (he could somehow not join the mailing list) and observed a difference when issuing "SET ROLE" as user postgres and as a non-superuser. When I connect as su