| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Lauris Ulmanis <lauris(dot)ulmanis(at)mykoob(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4919: CREATE USER command slows down system performance |
| Date: | 2009-07-14 15:09:15 |
| Message-ID: | 4A5C9F9B.80307@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
Lauris Ulmanis wrote:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-07-14 15:15:15 | Re: SPI_ERROR_CONNECT within pl/pgsql, PG 8.4 |
| Previous Message | Tom Lane | 2009-07-14 14:42:09 | Re: SPI_ERROR_CONNECT within pl/pgsql, PG 8.4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ning | 2009-07-15 03:10:44 | Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 |
| Previous Message | Lauris Ulmanis | 2009-07-14 13:14:27 | CREATE USER command slows down when user count per server reaches up to 500 000 |