"Greg Fausak" <lgfausak@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
