CREATE USER command slows down when user count per server reaches up to 500 000

Поиск
Список
Период
Сортировка
От Lauris Ulmanis
Тема CREATE USER command slows down when user count per server reaches up to 500 000
Дата
Msg-id f84ac0fb0907140614x59488a01jd1583536dac609e7@mail.gmail.com
обсуждение исходный текст
Ответы Re: CREATE USER command slows down when user count per server reaches up to 500 000  ("Haszlakiewicz, Eric" <EHASZLA@transunion.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Wayne Conrad
Дата:
Сообщение: Poor overall performance unless regular VACUUM FULL
Следующее
От: ning
Дата:
Сообщение: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1