Lauris Ulmanis wrote: > The following bug has been logged online: > > Bug reference: 4919 > Logged by: Lauris Ulmanis > Email address: lauris.ulma...@mykoob.com > PostgreSQL version: 8.3.7, 8.4.0 > Operating system: Any > Description: CREATE USER command slows down system performance > Details: > > When user count in Postgres database reaches up to 500 000 - database > command of creating users 'CREATE USER' slows down to 5-10 seconds per user.
I don't see such slowdown here, by just issuing 500000 CREATE USER commands in a loop. > For each of user can be associated up to 10 roles with grants to system > objects. That may be related.. Can you produce a repeatable test case? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
