Hmm, strange, the commitfest system didn't pick up the email with patch 0006 for some reason, with message id 0c5a6b79-408c-4910-9b2e-4aa9a7b30...@app.fastmail.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
0007-pg_privileges-pg_ownerships-pg_get_acl.patch
Description: Binary data
