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

=?UTF-8?Q?Ulf_Lohbr=C3=BCgge?= writes: > I just ran "check_postgres.pl --action=bloat" and got the following output: > ... > Looks fine, doesn't it? A possible explanation is that something is taking an exclusive lock on some system catalog and holding it for a second

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

2017-11-07 22:39 GMT+01:00 Scott Marlowe : > On Tue, Nov 7, 2017 at 2:25 PM, Ulf Lohbrügge > wrote: > > 2017-11-07 20:45 GMT+01:00 Andres Freund : > >> > >> On 2017-11-07 18:48:14 +0100, Ulf Lohbrügge wrote: > >> > Hi, > >> >

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

On Tue, Nov 7, 2017 at 2:25 PM, Ulf Lohbrügge wrote: > 2017-11-07 20:45 GMT+01:00 Andres Freund : >> >> On 2017-11-07 18:48:14 +0100, Ulf Lohbrügge wrote: >> > Hi, >> > >> > 2017-11-07 16:11 GMT+01:00 Andres Freund : >> > >> > >

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

2017-11-07 20:45 GMT+01:00 Andres Freund : > On 2017-11-07 18:48:14 +0100, Ulf Lohbrügge wrote: > > Hi, > > > > 2017-11-07 16:11 GMT+01:00 Andres Freund : > > > > > Hi, > > > > > > On 2017-11-07 11:11:36 +0100, Ulf Lohbrügge wrote: > > > > I'm using

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

On 2017-11-07 18:48:14 +0100, Ulf Lohbrügge wrote: > Hi, > > 2017-11-07 16:11 GMT+01:00 Andres Freund : > > > Hi, > > > > On 2017-11-07 11:11:36 +0100, Ulf Lohbrügge wrote: > > > I'm using PostgreSQL 9.5.9 on Debian and experience slow execution of > > some > > > basic SET

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

Hi, 2017-11-07 16:11 GMT+01:00 Andres Freund : > Hi, > > On 2017-11-07 11:11:36 +0100, Ulf Lohbrügge wrote: > > I'm using PostgreSQL 9.5.9 on Debian and experience slow execution of > some > > basic SET statements. > > > > I created about 1600 roles and use that setup for a

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

Hi, On 2017-11-07 11:11:36 +0100, Ulf Lohbrügge wrote: > I'm using PostgreSQL 9.5.9 on Debian and experience slow execution of some > basic SET statements. > > I created about 1600 roles and use that setup for a multi tenancy > application: Hm. How often do you drop/create these roles? How

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

Hi there, I'm using PostgreSQL 9.5.9 on Debian and experience slow execution of some basic SET statements. I created about 1600 roles and use that setup for a multi tenancy application: --snip-- -- create one role per tenant CREATE ROLE tenant1; ... CREATE ROLE tenant1600; -- create admin role