Maximum realistic number of database user accounts?

Поиск
Список
Период
Сортировка
От Greg Fausak
Тема Maximum realistic number of database user accounts?
Дата
Msg-id 8c7b802f0802140916r1b052875kebbe459adaa1c9ae@mail.gmail.com
обсуждение исходный текст
Ответы Re: Maximum realistic number of database user accounts?  (Erik Jones <erik@myemma.com>)
Re: Maximum realistic number of database user accounts?  ("Christopher Browne" <cbbrowne@gmail.com>)
Re: Maximum realistic number of database user accounts?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Howdy,

I find that user accounts are very good for
helping me protect application access to the database.
That is, instead of giving a user 1 account, I may give hem
10, and each of those accounts are restricted in the database
in different ways.  Anyway, I'm wondering what the maximum number of
user accounts can
be in a postgres database?

Can I create a database with 1 million login roles and expect performance to
be good? 10 million?

Thanks,
-g


--
Greg Fausak
greg@thursday.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Order of SUBSTR and UPPER in statement
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: How to cope with low disk space