From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Create a syscache for pg_database-indexed-by-oid, and make use of |
Date: | 2006-05-03 22:45:26 |
Message-ID: | 20060503224526.D49159FB270@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Create a syscache for pg_database-indexed-by-oid, and make use of it
in various places that were previously doing ad hoc pg_database searches.
This may speed up database-related privilege checks a little bit, but
the main motivation is to eliminate the performance reason for having
ReverifyMyDatabase do such a lot of stuff (viz, avoiding repeat scans
of pg_database during backend startup). The locking reason for having
that routine is about to go away, and it'd be good to have the option
to break it up.
Modified Files:
--------------
pgsql/src/backend/catalog:
aclchk.c (r1.127 -> r1.128)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c.diff?r1=1.127&r2=1.128)
pgsql/src/backend/commands:
dbcommands.c (r1.179 -> r1.180)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.179&r2=1.180)
vacuum.c (r1.328 -> r1.329)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c.diff?r1=1.328&r2=1.329)
pgsql/src/backend/postmaster:
autovacuum.c (r1.17 -> r1.18)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/autovacuum.c.diff?r1=1.17&r2=1.18)
pgsql/src/backend/utils/cache:
syscache.c (r1.102 -> r1.103)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/syscache.c.diff?r1=1.102&r2=1.103)
pgsql/src/backend/utils/init:
postinit.c (r1.164 -> r1.165)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/postinit.c.diff?r1=1.164&r2=1.165)
pgsql/src/include/utils:
acl.h (r1.95 -> r1.96)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h.diff?r1=1.95&r2=1.96)
syscache.h (r1.62 -> r1.63)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/syscache.h.diff?r1=1.62&r2=1.63)
From | Date | Subject | |
---|---|---|---|
Next Message | User Nwakefield | 2006-05-04 00:16:55 | bizgres - bizgres: Fixes 1. |
Previous Message | User Nwakefield | 2006-05-03 17:29:57 | bizgres - bizgres: Oracle Metadata |