"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