On Thu, Jun 13, 2024, at 00:14, Joel Jacobson wrote: > Changes since patch 0005 from 2021-03-25: > * 0006-pg_privileges-and-pg_ownerships.patch
- Also much faster now thanks to pg_get_acl(): Test with 100000 tables: SELECT COUNT(*) FROM pg_permissions_union_all; Time: 1466.504 ms (00:01.467) Time: 1435.520 ms (00:01.436) Time: 1459.396 ms (00:01.459) SELECT COUNT(*) FROM pg_privileges; Time: 292.257 ms Time: 288.406 ms Time: 294.831 ms