Re: CREATE USER command slows down when user count per server reaches up to 500 000

From: "Haszlakiewicz, Eric" <EHASZLA(at)transunion(dot)com>
To: "Lauris Ulmanis" <lauris(dot)ulmanis(at)mykoob(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: CREATE USER command slows down when user count per server reaches up to 500 000
Date: 2009-07-15 21:38:15
Message-ID: 9D29FD18CBD74A478CBA86E6EF6DBAD403DBBDB5@CHI4EVS04.corp.transunion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>-----Original Message-----
>From: pgsql-performance-owner(at)postgresql(dot)org
>
>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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Wayne Conrad 2009-07-15 22:03:50 Re: Poor overall performance unless regular VACUUM FULL
Previous Message Scott Mead 2009-07-15 15:33:03 Re: Performance comparison between Postgres and Greenplum