| From: | "Lauris Ulmanis" <lauris(dot)ulmanis(at)mykoob(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4919: CREATE USER command slows down system performance |
| Date: | 2009-07-14 12:39:10 |
| Message-ID: | 200907141239.n6ECdAgj094311@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
The following bug has been logged online:
Bug reference: 4919
Logged by: Lauris Ulmanis
Email address: lauris(dot)ulmanis(at)mykoob(dot)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.
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marek Lewczuk | 2009-07-14 12:54:12 | Re: SPI_ERROR_CONNECT within pl/pgsql, PG 8.4 |
| Previous Message | Frank Spies | 2009-07-14 09:20:31 | Re: BUG #4918: Weird input syntax for intervals |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lauris Ulmanis | 2009-07-14 13:14:27 | CREATE USER command slows down when user count per server reaches up to 500 000 |
| Previous Message | Albe Laurenz | 2009-07-14 09:39:59 | Re: embedded sql regression from 8.2.4 to 8.3.7 |