Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group