> On Nov 16, 2021, at 7:28 AM, Tom Lane <t...@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 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.
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
