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

From: Lauris Ulmanis <lauris(dot)ulmanis(at)mykoob(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: CREATE USER command slows down when user count per server reaches up to 500 000
Date: 2009-07-14 13:14:27
Message-ID: f84ac0fb0907140614x59488a01jd1583536dac609e7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2009-07-14 15:09:15 Re: BUG #4919: CREATE USER command slows down system performance
Previous Message Lauris Ulmanis 2009-07-14 12:39:10 BUG #4919: CREATE USER command slows down system performance