Re: BUG #4919: CREATE USER command slows down system performance - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4919: CREATE USER command slows down system performance
Date
Msg-id 20090901025941.GA6662@alvh.no-ip.org
Whole thread Raw
In response to BUG #4919: CREATE USER command slows down system performance  ("Lauris Ulmanis" <lauris.ulmanis@mykoob.com>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: "Sheng Y. Cheng"
Date:
Subject: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.
Next
From: Bhushan Verma
Date:
Subject: Re: psql: FATAL: the database system is in recovery mode