pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedCREATE STATISTICS and partitoins/inheritance
4+ messages / 2 participants
[nested] [flat]
* CREATE STATISTICS and partitoins/inheritance
@ 2022-08-17 19:30 Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2022-08-17 19:30 UTC (permalink / raw)
To: pgsql-docs; +Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
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>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CREATE STATISTICS and partitoins/inheritance
@ 2022-09-01 03:15 Bruce Momjian <bruce@momjian.us>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2022-09-01 03:15 UTC (permalink / raw)
To: pgsql-docs; +Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
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 want to clarify the ANALYZE docs related to parent tables, but that
will be done in another email.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CREATE STATISTICS and partitoins/inheritance
@ 2022-09-01 05:04 Justin Pryzby <pryzby@telsasoft.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Justin Pryzby @ 2022-09-01 05:04 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-docs@postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CREATE STATISTICS and partitoins/inheritance
@ 2022-09-01 12:07 Bruce Momjian <bruce@momjian.us>
parent: Justin Pryzby <pryzby@telsasoft.com>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2022-09-01 12:07 UTC (permalink / raw)
To: Justin Pryzby <pryzby@telsasoft.com>; +Cc: pgsql-docs@postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>
On Thu, Sep 1, 2022 at 12:04:43AM -0500, Justin Pryzby wrote:
> 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.
Yes.
> > 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 ?
Already posted --- the topic is "Duplicate text in ANALYZE related to
inheritance/parents".
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-09-01 12:07 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-08-17 19:30 CREATE STATISTICS and partitoins/inheritance Bruce Momjian <bruce@momjian.us>
2022-09-01 03:15 ` Bruce Momjian <bruce@momjian.us>
2022-09-01 05:04 ` Justin Pryzby <pryzby@telsasoft.com>
2022-09-01 12:07 ` Bruce Momjian <bruce@momjian.us>
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