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