Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] pg_permissions - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: [PATCH] pg_permissions
Date
Msg-id 78793ec1-5ad1-4bb0-ae84-7085e4429e77@app.fastmail.com
Whole thread Raw
In response to Re: [PATCH] pg_permissions  ("Joel Jacobson" <joel@compiler.org>)
Responses Re: [PATCH] pg_permissions
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Harmonizing pg_bsd_indent parameter names
Next
From: Nathan Bossart
Date:
Subject: Re: Changing default -march landscape