Re: Partitioned table statistics vs autoanalyze - Mailing list pgsql-performance

From Kamil Frydel
Subject Re: Partitioned table statistics vs autoanalyze
Date
Msg-id d36e33f6-0191-f471-1e93-18e7dbc2327c@gmail.com
Whole thread Raw
In response to Re: Partitioned table statistics vs autoanalyze  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
> In v14 (which is currently in beta), autoanalyze will process the partitioned
> table automatically:
> https://www.postgresql.org/docs/14/release-14.html
> |Autovacuum now analyzes partitioned tables (Yuzuko Hosoya, Álvaro Herrera)
> |Insert, update, and delete tuple counts from partitions are now propagated to their parent tables so autovacuum
knowswhen to process them.
 
> 

Thank you for the prompt reply! Changes in v14 sound promising.


-- 
Best regards
Kamil Frydel



pgsql-performance by date:

Previous
From: Manoj Kumar
Date:
Subject: Performance Issue on a table
Next
From: "ldh@laurent-hasson.com"
Date:
Subject: RE: Big performance slowdown from 11.2 to 13.3