From: Kamil Frydel <k.frydel@gmail.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Partitioned table statistics vs autoanalyze
Date: Thu, 22 Jul 2021 16:20:16 +0200
Message-ID: <d36e33f6-0191-f471-1e93-18e7dbc2327c@gmail.com> (raw)
In-Reply-To: <20210722121559.GE19620@telsasoft.com>
References: <0d1b394b-bec9-8a71-a336-44df7078b295@gmail.com>
<20210722121559.GE19620@telsasoft.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: k.frydel@gmail.com, pryzby@telsasoft.com, pgsql-performance@lists.postgresql.org
Subject: Re: Partitioned table statistics vs autoanalyze
In-Reply-To: <d36e33f6-0191-f471-1e93-18e7dbc2327c@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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