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 1kG8UB-0003s3-44 for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2020 22:22:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kG8U9-0005ki-Vo for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2020 22:22:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kG8U9-0005kb-PA for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2020 22:22:37 +0000 Received: from mail-qk1-x741.google.com ([2607:f8b0:4864:20::741]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kG8U6-0003fI-Mx for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2020 22:22:37 +0000 Received: by mail-qk1-x741.google.com with SMTP id o16so4069327qkj.10 for ; Wed, 09 Sep 2020 15:22:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=ZOAqzAu1Ox2jGRiz1UeB2Bd75vU+10aiKhsjfFiqLbQ=; b=F6KayRdZjD2ai6i0w2oTNM5vgiyP5J+c4dpRNZlcMvSo5aANtDscZny3fqkI1iJ93D BdAQ2WXqgtUbmcBamWf2GuicmI5dx0GDszwbBCq3bSEq2nMBMXHA7dY0htm4h2QJ6VRu 1h7FynKoGVBc2XF1pCPOuFMUZfXz73lXa0jTvBCsvLv5i2p96xhENionLlGhUIiWL92B 6wKTir6KeKVYuResUdFc+6vJaaY1xzFPkdMdSoxSa9loKmaf31KU5xs/ry23jo0rqvay MChb1EUPtriHts8+BXrd0WKxC/wvzInt795ehUoLcTacqfCEYv3RMDcms8iysXDdsbw3 iwWw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=ZOAqzAu1Ox2jGRiz1UeB2Bd75vU+10aiKhsjfFiqLbQ=; b=Inia3cV2ho9p83I48h9vdmnYNsZU9DbRNRquJHGfPEu/GIxH0Atwf77T8uTLEkbODb kzR7bn5g1e0JLIF74oXC4aguylACNU/EW7vHL9hGSl0/E+Q1TomK77emNcLVi1Ki8nqT xWBlh652Fl+ZwuSxx2v2+AafLL47CRBLnMi3NpOZ6tXtvhuZhZ83A9nAk2+q3OKLQVAK vuuuLa8Mxs70CewfxjQjBiOcAaybKtv1zWG04Gkid1LBQu+xgT80BrTOaVv7r6Viqixa ejPY/JXmUMfJMq7XUlW57XoLDKOO0PhFRuPLmt6ZT8c0HRhC6LX+2pHiRIkSzUSGlgf+ NtAA== X-Gm-Message-State: AOAM530R6Mnl4nINs6DVLV4ybsjgolfPKN1QPhhq9t/3soCHGJKyUXVD G/avUDh72gFH0+V0ufPP6+y9OutQhh6jnhx3y9h0DOymcS1vNnxY/8wJ6PencaT7QR4yYg11ty5 510cmTJmkevBQ/Lup9+8mhmptMhQaudTZ7ibz5FSHz70Xcqgngs8IAJN6BkN1SkKieV5dSXfKfJ O3ksi69pwLAA5BqVe7nC8= X-Google-Smtp-Source: ABdhPJxlI4i1Mq3/WjMEKO48UevlYmqQMe91RZRSBS6M9L+fd/CxoNoXry7iwWiL1wUrUsE0YdivlA== X-Received: by 2002:a37:6f41:: with SMTP id k62mr5046501qkc.241.1599690152684; Wed, 09 Sep 2020 15:22:32 -0700 (PDT) Received: from perhan.alvh.no-ip.org ([190.95.19.47]) by smtp.gmail.com with ESMTPSA id 25sm4317025qks.41.2020.09.09.15.22.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 09 Sep 2020 15:22:32 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 959D62A1997; Wed, 9 Sep 2020 19:22:30 -0300 (-03) Date: Wed, 9 Sep 2020 19:22:30 -0300 From: Alvaro Herrera To: Justin Pryzby Cc: Georgios Kokolatos , pgsql-hackers@lists.postgresql.org Subject: Re: v13: show extended stats target in \d Message-ID: <20200909222230.GA30448@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200909213627.GW18552@telsasoft.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Sep-09, Justin Pryzby wrote: > As for the discussion about a separator, I think maybe a comma is enough. I > doubt anyone is going to think that you can get a valid command by prefixing > this by "CREATE STATISTICS". Actually, it didn't even occur to me it was valid > command without the stats target - after all, that's not true of indexes. By the way, I got into this because of your comment in https://postgr.es/m/20200901011429.GZ5450@telsasoft.com on whether we needed CREATE STATISTICS to have a clause for this. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services