Skip site navigation (1) Skip section navigation (2)

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: 2009-09-01 02:59:41
Message-ID: 20090901025941.GA6662@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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.

In response to

pgsql-performance by date

Next:From: Kevin KempterDate: 2009-09-01 08:45:58
Subject: moving data between tables causes the db to overwhelm the system
Previous:From: Mike IvanovDate: 2009-09-01 01:10:39
Subject: Re: Number of tables

pgsql-bugs by date

Next:From: Bhushan VermaDate: 2009-09-01 05:10:20
Subject: Re: psql: FATAL: the database system is in recovery mode
Previous:From: Sheng Y. ChengDate: 2009-08-31 22:53:31
Subject: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group