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 1oTcNp-0000Kb-Cg for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 05:04:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oTcNo-00054D-AM for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 05:04:52 +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 1oTcNo-000543-3F for pgsql-docs@lists.postgresql.org; Thu, 01 Sep 2022 05:04:52 +0000 Received: from mail-io1-xd30.google.com ([2607:f8b0:4864:20::d30]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oTcNj-0003xO-DQ for pgsql-docs@postgresql.org; Thu, 01 Sep 2022 05:04:51 +0000 Received: by mail-io1-xd30.google.com with SMTP id c4so13685313iof.3 for ; Wed, 31 Aug 2022 22:04:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date; bh=O/qfA+y7iqcCU+Zn9zpwWUeMHzoMRGutIiIVQwd0/wk=; b=aT0sGEXUpb11FxMBJz5NmzhgdI8AbBYlmuqroT2Wd37Bxow7TTIYWjHfwdysRj2Gx0 bI5k75Hbaf8uFS/+5pzCLCuv0Ofd/XixKt6I1oGPlEGOB5f2SfxvJcFyJiRmL50UqsZX lfdrirBKFsNc/YCpOONYcvgj1wttaWimdvNoZRXafLG1tsl/N2WFz8Z+4DPgsGvxBHo0 QjAezwdqLlG+cP4UrgSacRASxxQ0j07ECrVJwizVzxAgTO3LuPqQ9O13Ev/42E1X4CbH wpxoTMXGHgxhZlzhpYo9WfX87H3OaEZNPBNTHZeVUD6hra0REO9p3vdcLhZacg9WS+f9 fU5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date; bh=O/qfA+y7iqcCU+Zn9zpwWUeMHzoMRGutIiIVQwd0/wk=; b=oufeM4HSZF1iCViNLF52Vi+cAJAHZDFghjfl9FTPBS4tPq7edeuRAqJjCWh0gNqnk0 cY93k/jM/HbGVPyA31UKPRRlf6UQRbceTCpYgaFnfbpVx/BTbyqB/Q4SHr/7G1L0lizZ IKw2vOhNz7WXMPEbeK79cc2nQx6lVf2JM4zrpMWvzwoCuXKmuK4kZwVaeq0S46tM5orY u+f9fGx32L0jOgtiiQVVwozZvMzl4ZoEwBdh5qhOVa6FAwnLAD20VJ6G5zc7852tqC1j ffv6SjNPcp8JLeb6dgWMqoJAwHNSJyhiLub71Bk8cIJyHTSz8+i1S5WYPICFs/msQSQN 6B6Q== X-Gm-Message-State: ACgBeo2FswHUxekfGy2+ck8x2seZemtGC/fjI+ITAUoQ9Il8Fzqohb/p QGmN8T2ejJBGSqvl3bm8m4cg9CFVhGVotg== X-Google-Smtp-Source: AA6agR7Bq0wEDB1C2VmComNTvDgZ3XL066Zn7XQLSZ/1XcA92I0GC3fqyDDB1p8+pBoqyXJKRH68wQ== X-Received: by 2002:a05:6602:2c4a:b0:68a:29de:e0b9 with SMTP id x10-20020a0566022c4a00b0068a29dee0b9mr14331762iov.146.1662008685051; Wed, 31 Aug 2022 22:04:45 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id b17-20020a026f51000000b00349c9c99db9sm7647936jae.144.2022.08.31.22.04.44 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 31 Aug 2022 22:04:44 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id CD4B1801058; Thu, 1 Sep 2022 00:04:43 -0500 (CDT) Date: Thu, 1 Sep 2022 00:04:43 -0500 From: Justin Pryzby To: Bruce Momjian Cc: pgsql-docs@postgresql.org, Tomas Vondra Subject: Re: CREATE STATISTICS and partitoins/inheritance Message-ID: <20220901050443.GH31833@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 31, 2022 at 11:15:41PM -0400, Bruce Momjian wrote: > On Wed, Aug 17, 2022 at 03:30:11PM -0400, Bruce Momjian wrote: > > In looking at CREATE STATISTICS, I was confused how inheritance and > > partisions were handled, so I confirmed with Tomas that the ANALYZE > > manual page accurately describes how extended statistics are handled > > since PG 15, so I plan to apply this patch to the CREATE STATISTICS > > docs. > > Turns out analyze has information about parent table processing all the > way back to PG 10, so I applied the patch back to that version. I didn't see this until now, but you're probably referring to the docs added at 61fa6ca79b3c566f44831a33bb226f7358ed4511. > I want to clarify the ANALYZE docs related to parent tables, but that > will be done in another email. Would you copy me on that ? -- Justin