A million users
Hi A simple question before design. Would there be performance issues having perhaps a million users, each having several roles? I could imagine a user would have on average 10-20 roles. Roles would be used to allow or restrict access to tables or rows according to the business rules. /kaare
Re: Fwd: A million users
Hi Dominique Hi. Sure, that's a good point, and a best practice IMHO. But I already do that, and the original question remain, i.e. how does PostgreSQL with thousands or millions of roles? Sorry if my original post was unclear, but I don't expect that there will be much more than perhaps a hundred roles. Each may have from a few up to a million users in them, though. /kaare
Re: Fwd: A million users
Hi That said, having a million users is a bit strange. Do you want to give each visitor to your website a unique Postgres role, or something like that? I think this is unusual, but it should work. OK, thanks for the feedback, all. It may not be necessary to have such a fine grained system, but I was just wondering. the caches used to store contents of system catalogs. I think you should test it out and see what happens. I haven't seen any published _actual_ benchmarks on this point. I will, if this progresses. I did want to know if something like this has been tried and failed before. /kaare
