grants gives - Search results

Mailing lists  >>  pgsql-general  >>  Thread

2024-11-13 21:01:58 | Re: Fwd: A million users (walther@technowledgy.de)

granted to each other (pg_auth_members). Except for one thing, we have never had any real problems with this. We didn't observe anything getting massively worse with many roles, even though

Mailing lists  >>  pgsql-general  >>  Thread

2024-11-13 16:40:16 | Re: Fwd: A million users (Alvaro Herrera)

grant all one hundred roles to each of the million users, you would end up with 100_000_000 rows in pg_auth_member). I would expect such a system to work mostly fine