Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #4919: CREATE USER command slows down system performance
- 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: Mon, 31 Aug 2009 22:59:41 -0400
- Message-id: <20090901025941.GA6662@alvh.no-ip.org> <text/plain>
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.
- Prev by Date: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.
- Previous by thread: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.
- Indexes: