Re:Securing Your PostgreSQL DB with Roles and Privileges
by aeonsky on Saturday August 12, 2023 @02:25PM
(#37102861)
Yes, my team had a direct issue with this on Aurora Postgres, at least. This is PG9 but then kept happening all the way into PG12 until we got rid of all but like 5 roles. Above like 4000 roles we experienced a significant lag on every query, sometimes on the order of seconds. At scaled somewhat linearly. I even wrote to Tom Lane and he said that area of Postgres is poorly optimized.
[ Parent
| on HN ]