pgsql: Remove unnecessary UPDATE commands to assign explicit ACLs to

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Remove unnecessary UPDATE commands to assign explicit ACLs to
Date: 2005-04-12 19:29:24
Message-ID: 20050412192924.86BA953417@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Remove unnecessary UPDATE commands to assign explicit ACLs to functions
and PL languages during initdb. The default permissions for these objects
are the same as what we were assigning anyway, so there is no need to
expend space in the catalogs on them. The space cost is particularly
significant in pg_proc's indexes, which are bloated by about a factor of 2
by the full-table update, and can never really recover the space.
initdb not forced, since the change has no actual impact on behavior.

Modified Files:
--------------
pgsql/src/bin/initdb:
initdb.c (r1.80 -> r1.81)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/initdb/initdb.c.diff?r1=1.80&r2=1.81)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-04-12 19:45:44 pgsql: Adjust pg_cast.h so that the OIDs assigned to built-in casts come
Previous Message Peter Eisentraut 2005-04-12 14:19:43 pgsql: Revert mistaken renaming of UTF-8.