| From: | Alvaro Herrera <alvherre(at)commandprompt(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-09-01 02:59:41 |
| Message-ID: | 20090901025941.GA6662@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-performance |
Lauris Ulmanis wrote:
> 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.
A bunch of commits along the direction of eliminating what we thought
was the main cause of the slowdown have just concluded. If you could
grab the current CVS version (or alternative a snapshot tarball from the
FTP, but make sure it contains my commit as of 5 minutes ago) and try
your test case with it, it would be great.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bhushan Verma | 2009-09-01 05:10:20 | Re: psql: FATAL: the database system is in recovery mode |
| Previous Message | Sheng Y. Cheng | 2009-08-31 22:53:31 | BUG #5025: Aggregate function with subquery in 8.3 and 8.4. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2009-09-01 08:45:58 | moving data between tables causes the db to overwhelm the system |
| Previous Message | Mike Ivanov | 2009-09-01 01:10:39 | Re: Number of tables |