Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\))
Subject: Re: Granting SET and ALTER SYSTE privileges for GUCs
From: Mark Dilger <mark.dilger@enterprisedb.com>
In-Reply-To: <2226903.1637076537@sss.pgh.pa.us>
Date: Tue, 16 Nov 2021 07:52:06 -0800
Cc: Robert Haas <robertmhaas@gmail.com>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>,
 Andrew Dunstan <andrew@dunslane.net>
Content-Transfer-Encoding: quoted-printable
Message-Id: <A6157072-B564-4171-8599-068C8D65BE9C@enterprisedb.com>
References: <3D691E20-C1D5-4B80-8BA5-6BEB63AF3029@enterprisedb.com>
 <CA+TgmobaKUYZhfXs-7kHjsmDmkcttH7-r9E2BJXUHtv9mkUUcw@mail.gmail.com>
 <2226110.1637075835@sss.pgh.pa.us>
 <CA+TgmoYWqjpHEogdCEbRwzUb5ZoEaUt8ciNUXFCwLZDWBe+_BA@mail.gmail.com>
 <2226903.1637076537@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/A6157072-B564-4171-8599-068C8D65BE9C%40enterprisedb.com>
Precedence: bulk


> On Nov 16, 2021, at 7:28 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> True; as long as the expectation is that entries will exist for only
> a tiny subset of GUCs, it's probably fine.

I understand that bloating a frequently used catalog can be pretty =
harmful to performance.  I wasn't aware that the size of an infrequently =
used catalog was critical.  This new catalog would be used during GRANT =
SET ... and GRANT ALTER SYSTEM commands, which should be rare, and =
potentially consulted when SET or ALTER SYSTEM commands are issued.  Is =
there a more substantial performance impact to this than I'm aware?  It =
can be a bit challenging to run performance tests on such things, given =
the way everything interacts with everything else.=20

=E2=80=94
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company