Re: [PATCH] pg_permissions

Hmm, strange, the commitfest system didn't pick up the email with patch 0006 for some reason,
with message id 0c5a6b79-408c-4910-9b2e-4aa9a7b30f3a(at)app(dot)fastmail(dot)com

It's rebased to latest HEAD, so not sure why.

Maybe it got confused when I quickly afterwards sent a new email without a patch?

Here is a new attempt, file content unchanged, just named to 0007 and added "pg_get_acl" to the name.

On Thu, Jun 13, 2024, at 04:00, Joel Jacobson wrote:
> 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

--
Kind regards,

Joel