Re: How about a psql backslash command to show GUCs?

On 4/11/22 3:12 PM, Tom Lane wrote:
> "Jonathan S. Katz" <jkatz(at)postgresql(dot)org> writes:
>> On 4/9/22 12:27 PM, Tom Lane wrote:
>>> Sure, but then you do "\dconfig *". With there being several hundred
>>> GUCs (and no doubt more coming), I'm not sure that "show me every GUC"
>>> is a common use-case at all, let alone so common as to deserve being
>>> the default behavior.
>>>
>>> One thing we could perhaps do to reduce confusion is to change the
>>> table heading when doing this, say from "List of configuration parameters"
>>> to "List of non-default configuration parameters".
>
>> Reasonable points. I don't have any objections to this proposal.
>
> Hearing no further comments, done like that.

Thanks!

I have a usability comment based on my testing.

I ran "\dconfig" and one of the settings that came up was
"max_connections" which was set to 100, or the default.

I had noticed that "max_connections" was uncommented in my
postgresql.conf file, which I believe was from the autogenerated
provided by initdb.

Similarly, min_wal_size/max_wal_size were in the list and set to their
default values. These were also uncommented in my postgresql.conf from
the autogeneration.

My question is if we're only going to list out the settings that are
customized, are we going to:

1. Hide a setting if it matches a default value, even if a user set it
to be the default value? OR
2. Comment out all of the settings in a generated postgresql.conf file?

Thanks,

Jonathan