Re: Maximum realistic number of database user accounts?

"Greg Fausak" <lgfausak@gmail.com> writes:
> Can I create a database with 1 million login roles and expect performance to
> be good? 10 million?

Probably not, as (to my knowledge) no one has ever done any performance
testing in that domain.  I doubt anyone's worked with more than a few
thousand roles.  I can definitely say that granting permissions on the
same object to many thousands of roles separately would be a Bad Idea.

Feel free to try it, but I'd *strongly* advise doing some performance
testing before you commit to such a design.  And think about how you can
use groups to reduce redundancy in the permissions data.

            regards, tom lane