CREATE STATISTICS and partitoins/inheritance
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:
parent.difftext/x-diff; charset=us-asciiDownload+3-1
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
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
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