Home > mailing lists

CREATE USER command slows down when user count per server reaches up to 500 000 - Mailing list pgsql-performance

From	Lauris Ulmanis
Subject	CREATE USER command slows down when user count per server reaches up to 500 000
Date	July 15, 2009 03:33:56
Msg-id	f84ac0fb0907140614x59488a01jd1583536dac609e7@mail.gmail.com Whole thread Raw
Responses	Re: CREATE USER command slows down when user count per server reaches up to 500 000 ("Haszlakiewicz, Eric" <EHASZLA@transunion.com>)
List	pgsql-performance

Tree view

When users count in Postgres database reaches up to 500 000 - database
command of creating users 'CREATE USER' slows down to 5-10 seconds per user.

What could be a reason of this problem and is there any solution how to
avoid it?

For each of user can be associated up to 10 roles with grants to system
objects.

pgsql-performance by date:

From: Wayne Conrad
Date: 15 July 2009, 03:33:53
Subject: Poor overall performance unless regular VACUUM FULL

From: ning
Date: 15 July 2009, 03:59:47
Subject: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1

CREATE USER command slows down when user count per server reaches up to 500 000 - Mailing list pgsql-performance

Previous

Next