> On Nov 16, 2021, at 7:28 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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
sizeof an infrequently used catalog was critical. This new catalog would be used during GRANT SET ... and GRANT ALTER
SYSTEMcommands, which should be rare, and potentially consulted when SET or ALTER SYSTEM commands are issued. Is there
amore substantial performance impact to this than I'm aware? It can be a bit challenging to run performance tests on
suchthings, given the way everything interacts with everything else.
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company