On Tue, Nov 7, 2017 at 2:25 PM, Ulf Lohbrügge <ulf.lohbruegge@xxxxxxxxx> wrote: > 2017-11-07 20:45 GMT+01:00 Andres Freund <andres@xxxxxxxxxxx>: >> >> On 2017-11-07 18:48:14 +0100, Ulf Lohbrügge wrote: >> > Hi, >> > >> > 2017-11-07 16:11 GMT+01:00 Andres Freund <andres@xxxxxxxxxxx>: >> > >> > > 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 many other >> > > roles/groups is one role a member of? >> > > >> > >> > I create between 10-40 roles per day. >> >> Could you VACUUM (VERBOSE, FREEZE) that table and report the output? Do >> you ever delete roles? > > > Which table do you mean exactly? pg_catalog.pg_authid? > > Sorry, forgot to write that: I delete about 2-3 roles per day. I'm gonna take a guess that pg_users or pg_roles has gotten bloated over time. Try running a vacuum full on both of them. It's also possible some other pg_xxx table is bloated out here too you might need to download something like checkpostgres.pl to check for bloat in system catalog tables. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
