>-----Original Message----- >From: pgsql-performance-owner@xxxxxxxxxxxxxx > >When users count in Postgres database reaches up to 500 000 - database >command of creating users 'CREATE USER' slows down to 5-10 >seconds per user. > >What could be a reason of this problem and is there any solution how to >avoid it? > >For each of user can be associated up to 10 roles with grants to system >objects. I have no idea about the performance issues, but I'm curious: how/why do you have so many users accessing your database? I'm drawing a blank on coming up with a use case where that many users are needed. eric -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
