Re: Partitioned table statistics vs autoanalyze

From: Kamil Frydel <k(dot)frydel(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Partitioned table statistics vs autoanalyze
Date: 2021-07-22 14:20:16
Message-ID: d36e33f6-0191-f471-1e93-18e7dbc2327c@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 knows when to process them.
>

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

--
Best regards
Kamil Frydel

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ldh@laurent-hasson.com 2021-07-22 15:00:33 RE: Big performance slowdown from 11.2 to 13.3
Previous Message Manoj Kumar 2021-07-22 13:54:25 Performance Issue on a table