From: | petere(at)postgresql(dot)org (Peter Eisentraut) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Speed up information schema privilege views Instead of expensive |
Date: | 2009-12-05 21:43:36 |
Message-ID: | 20091205214336.1F441753FB7@cvs.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Speed up information schema privilege views
Instead of expensive cross joins to resolve the ACL, add table-returning
function aclexplode() that expands the ACL into a useful form, and join
against that.
Also, implement the role_*_grants views as a thin layer over the respective
*_privileges views instead of essentially repeating the same code twice.
fixes bug #4596
by Joachim Wieland, with cleanup by me
Modified Files:
--------------
pgsql/src/backend/catalog:
information_schema.sql (r1.58 -> r1.59)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/information_schema.sql?r1=1.58&r2=1.59)
pgsql/src/backend/utils/adt:
acl.c (r1.150 -> r1.151)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/acl.c?r1=1.150&r2=1.151)
pgsql/src/include/catalog:
catversion.h (r1.554 -> r1.555)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.554&r2=1.555)
pg_proc.h (r1.554 -> r1.555)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h?r1=1.554&r2=1.555)
pgsql/src/include/utils:
acl.h (r1.109 -> r1.110)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h?r1=1.109&r2=1.110)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-12-06 02:55:55 | pgsql: Don't use a duplicate OID for aclexplode(). |
Previous Message | Peter Eisentraut | 2009-12-05 21:31:06 | pgsql: Information schema documentation Add a sentence of documentation |