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.
In response to
pgsql-performance by date
|Next:||From: Kevin Kempter||Date: 2009-09-01 08:45:58|
|Subject: moving data between tables causes the db to overwhelm the system|
|Previous:||From: Mike Ivanov||Date: 2009-09-01 01:10:39|
|Subject: Re: Number of tables|
pgsql-bugs by date
|Next:||From: Bhushan Verma||Date: 2009-09-01 05:10:20|
|Subject: Re: psql: FATAL: the database system is in recovery mode|
|Previous:||From: Sheng Y. Cheng||Date: 2009-08-31 22:53:31|
|Subject: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.|