Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ndDTy-0003IV-05 for pgsql-hackers@arkaria.postgresql.org; Sat, 09 Apr 2022 15:58:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ndDTv-0000a5-R0 for pgsql-hackers@arkaria.postgresql.org; Sat, 09 Apr 2022 15:58:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ndDTv-0000Zv-Gb for pgsql-hackers@lists.postgresql.org; Sat, 09 Apr 2022 15:58:35 +0000 Received: from mail-pj1-x102d.google.com ([2607:f8b0:4864:20::102d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ndDTs-0006F1-7t for pgsql-hackers@lists.postgresql.org; Sat, 09 Apr 2022 15:58:34 +0000 Received: by mail-pj1-x102d.google.com with SMTP id o5-20020a17090ad20500b001ca8a1dc47aso14461148pju.1 for ; Sat, 09 Apr 2022 08:58:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=M6F4Ao8CnFlAWN/Qx/M61x7/E5ycBd28vK+DdgEPCKs=; b=OYpDaM4dZYX+qS1oBrVDKeNKd8XcwL+az04Y9Aj/moz3nDJMbvO/NkAk81P9mhWxY4 0OZZbrUBE/UyZ2+pG0yiaJy1nBU7HzfOVnGo5SRQLeJ+tqCn2EfeBh+nwUdEAzq4ZiY2 xnI1bxt38Gog+A95V6cZas1x/U2elqyzdjvbiRRGbn50FE4qLp+qnRBijKy9eKsSO9PB X7wmGTfgHLtjLhNkCt1AwrrdrRLTPC10HwaiQSzgSc5ywSktT08/onaoCBiqgIVpvUIl YpCmM15nLO0DpMNlEO8JlXby0z2UsIGMv+kKzoOOOoLfIqia5/HnAFqC0uG2O6UGPHKn 2hGg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=M6F4Ao8CnFlAWN/Qx/M61x7/E5ycBd28vK+DdgEPCKs=; b=WeQfU0OZznKFmf8hHL6WWtAKPCevFrSgSFqXspedrqF1kFGJMWCNHLUJhEOmDiB95+ SkezQ7K67MHP5vsC0XyF/efYw8zdhDYiC4lN0xmj3yVW98dmHaPHRZ3vzQsEvTFKsVvW DQbCFEfkHWRbBwnN6FZrrEiOH8qA7gu0Vo7CVCsuOxwCh0HjwajzLcotTshwq8VosBup aMIC2NSFnPH7O3j7/OEQr4CE/2ZxnSzJui/EXUpQc37gwFSB3sEei0FSQEfbsoGhMEUl Dl8gohgqA0BisAsN1EliuPBr6lt/rqqarJo2mhaGd/SnPtSaX+owzTqyBaPf16+Bv00K tdMg== X-Gm-Message-State: AOAM531W4utZd6IRrLIR2w56iYVmkw7SHf3/5TBWDICnDhZc221obzGk jGTgp7QeVNxH4ry+n/4F+gY= X-Google-Smtp-Source: ABdhPJx+Fq/naQuY5FPf0SzCdnS3i0lJ0Lc/4w9UevIW4TKWwnL8EzyKA2UzjMKQDg1MbvFYrdckmw== X-Received: by 2002:a17:902:a98b:b0:156:40cc:ddf6 with SMTP id bh11-20020a170902a98b00b0015640ccddf6mr24677438plb.111.1649519910968; Sat, 09 Apr 2022 08:58:30 -0700 (PDT) Received: from jrouhaud (2001-b011-1005-38bf-f9a9-ed33-cd40-67a7.dynamic-ip6.hinet.net. [2001:b011:1005:38bf:f9a9:ed33:cd40:67a7]) by smtp.gmail.com with ESMTPSA id b80-20020a621b53000000b005059f5d7587sm2504668pfb.60.2022.04.09.08.58.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 09 Apr 2022 08:58:30 -0700 (PDT) Date: Sat, 9 Apr 2022 23:58:24 +0800 From: Julien Rouhaud To: Tom Lane Cc: Christoph Berg , Pavel Stehule , "David G. Johnston" , Joe Conway , Mark Dilger , Andrew Dunstan , David Rowley , Alvaro Herrera , PostgreSQL Developers Subject: Re: How about a psql backslash command to show GUCs? Message-ID: References: <3370142.1649348973@sss.pgh.pa.us> <2DB6EB50-04DF-49D1-BB5B-61C62898BB35@enterprisedb.com> <3370992.1649349445@sss.pgh.pa.us> <711e43b9-6499-6a8b-0802-fb549874658e@joeconway.com> <3400691.1649363759@sss.pgh.pa.us> <4105551.1649514677@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4105551.1649514677@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Apr 09, 2022 at 10:31:17AM -0400, Tom Lane wrote: > Christoph Berg writes: > > > I would think that if \dconfig showed the non-default settings only, > > it would be much more useful; the full list would still be available > > with "\dconfig *". This is in line with \dt only showing tables on the > > search_path, and "\dt *.*" showing all. > > Hm, I could get on board with that -- any other opinions? +1 for it, that's often what I'm interested in when looking at the GUCs in general. > (Perhaps there's an argument for omitting "override" > settings as well?) -0.1. Most are usually not useful, but I can see at least data_checksums and wal_buffers that are still interesting.