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 1kG9Bl-0005Zg-4Y for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2020 23:07:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kG9BE-0004wn-CB for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Sep 2020 23:07:08 +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 1kG9BE-0004wB-1x for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2020 23:07:08 +0000 Received: from mail-il1-x142.google.com ([2607:f8b0:4864:20::142]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kG9B9-0000Iu-RF for pgsql-hackers@lists.postgresql.org; Wed, 09 Sep 2020 23:07:06 +0000 Received: by mail-il1-x142.google.com with SMTP id m1so3940674ilj.10 for ; Wed, 09 Sep 2020 16:07:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=hl84xJcsDcT3hnu9io0m+ZaI9Qu+7UlZaNp/d4c+eQg=; b=BambFfoV2QoIppkCXYvxn9C925XXapud0+QS+dMSWWFuog8CYl2j9wWMvXIaKZVAfy IdPUN605SRWcSxxU99smH56rnu2itW9e88mw0LIk0hF1WNYx4iCm5WMmhS4nTjcVHsC1 GHjb2xxK2k66OME/f3BBMRJEyuaKxYg8zHZYXgn8wcVCb2Qh0Wv+j9lGu+SfqP6kmLqx AlAZhH93jD8cSP55QqLFKpTv4xyhG6795HYo5dAoZ7Q/UefcLWcbWahD/35NEFPTRnLk tnEXHqoyC3jCvnFnCA9dl3X2NJ2w16pMcXc44FrF66fxy7dHlPg6Ecw5xPvQyXbzbs4t h1DA== 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:references :mime-version:content-disposition:in-reply-to:user-agent; bh=hl84xJcsDcT3hnu9io0m+ZaI9Qu+7UlZaNp/d4c+eQg=; b=L9spSD0vWXXDia7oSHv7UCTp8xgDVOa3K2/qz5ZFd93BdxNtiGNQFGwCdNm6K9LUDY E1IKiux7+OBpqJNCzERTn/ta5wGWrrikASeejmOum0+CbAwDyzR8HdrYBVKhFrbTaHKJ syIy6HpDZuYyKDhQ+m7yb3BbLOefv51PAlCxHCDOW9qWtgXO9TveiiIR4N7OXFXji8wK Hx878VIYQWoO9uKynw+e7a/y3T+02EYnvrVS0INAIr4pXnOSoOjoPTQiZC6IMDov2/Av oSuzqxzARbON5Jg9UUitmsuU0MMtHyhmFxVwc+49bH8Rmwqb5IkTdCiTe90GiBsOUMs8 m+Kw== X-Gm-Message-State: AOAM531n0yswh49tGj/VfnmLgp/M2HyKy7xfT7PgPTZlaHE3bFU121Gu CSpgerXlMwywGCBrkGRjTxWX2g== X-Google-Smtp-Source: ABdhPJxy8vj/vfnxhPfCbNUV1O6FjnFyRF2HujiZkS8ng0XXjfwVKKh9hdgZaA+ggcLfn5woKWdzVw== X-Received: by 2002:a92:cec9:: with SMTP id z9mr5697644ilq.41.1599692823079; Wed, 09 Sep 2020 16:07:03 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id o1sm2146627ilo.32.2020.09.09.16.07.01 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 09 Sep 2020 16:07:02 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id E58D78002D1; Wed, 9 Sep 2020 18:07:00 -0500 (CDT) Date: Wed, 9 Sep 2020 18:07:00 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Georgios Kokolatos , pgsql-hackers@lists.postgresql.org Subject: Re: v13: show extended stats target in \d Message-ID: <20200909230700.GZ18552@telsasoft.com> References: <20200909213627.GW18552@telsasoft.com> <20200909222230.GA30448@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200909222230.GA30448@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Sep 09, 2020 at 07:22:30PM -0300, Alvaro Herrera wrote: > 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. And I agree that it does not - the question was raised during development of the feature, and nobody sees a need. I asked since I didn't know and I didn't want it to be missed for lack of asking. -- Justin