pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
Subject: CREATE STATISTICS and partitoins/inheritance
Date: Wed, 17 Aug 2022 15:30:11 -0400
Message-ID: <Yv1Bw8J+1pYfHiRl@momjian.us> (raw)

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.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson

Attachments:

  [text/x-diff] parent.diff (689B, ../Yv1Bw8J+1pYfHiRl@momjian.us/2-parent.diff)
  download | inline diff:
diff --git a/doc/src/sgml/ref/create_statistics.sgml b/doc/src/sgml/ref/create_statistics.sgml
index b847944f37..2a9a0bf932 100644
--- a/doc/src/sgml/ref/create_statistics.sgml
+++ b/doc/src/sgml/ref/create_statistics.sgml
@@ -146,7 +146,9 @@ CREATE STATISTICS [ [ IF NOT EXISTS ] <replaceable class="parameter">statistics_
     <listitem>
      <para>
       The name (optionally schema-qualified) of the table containing the
-      column(s) the statistics are computed on.
+      column(s) the statistics are computed on;  see <xref
+      linkend="sql-analyze"> for an explanation of the handling of
+      inheritance and partitions.
      </para>
     </listitem>
    </varlistentry>

view thread (4+ messages)  latest in thread

Message-ID: <Yv1Bw8J+1pYfHiRl@momjian.us>
Permalink:  ../Yv1Bw8J+1pYfHiRl@momjian.us/
Also on:    postgresql.org/message-id/Yv1Bw8J+1pYfHiRl@momjian.us

copy link · copy postgr.es · copy git am

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: bruce@momjian.us, tomas.vondra@enterprisedb.com
  Subject: Re: CREATE STATISTICS and partitoins/inheritance
  In-Reply-To: <Yv1Bw8J+1pYfHiRl@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox