Thread: 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
Attachment
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