Re: Extremely slow to establish connection when user has a high number of roles

2024-04-21 Thread Tom Lane
Michal Charemza writes: > Tom Lane writes: >> I'm fairly sure that if that exists it's always noticed first, >> bypassing the need for any role membership tests. So please >> confirm whether your production database has revoked PUBLIC >> connect privilege. > I realised that in fact we hadn't re

Re: Extremely slow to establish connection when user has a high number of roles

2024-04-21 Thread Michal Charemza
Tom Lane writes: > Do you do bulk > permissions updates that might affect thousands of role memberships at > once? So we do regularly update role memberships - essentially a sync from a separate database, and some could well have happened just before connections, but it's more in the tens at a ti