From: Michael Paquier <michael@paquier.xyz>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: henri.chapelle@dbandmore.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables
Date: Mon, 29 May 2023 14:23:05 +0900
Message-ID: <ZHQ2uUIkRmuY6Glt@paquier.xyz> (raw)
In-Reply-To: <20230526.180207.2066564295031330076.horikyota.ntt@gmail.com>
References: <20230526.091536.1662896499070434031.horikyota.ntt@gmail.com>
<ZHBILpg7K4ylJ8zl@paquier.xyz>
<20230526.164935.906413482200781902.horikyota.ntt@gmail.com>
<20230526.180207.2066564295031330076.horikyota.ntt@gmail.com>
On Fri, May 26, 2023 at 06:02:07PM +0900, Kyotaro Horiguchi wrote:
> For 12 or later, pg_partition_ancestors() is available. Thus something
> like the following query would work.
Yes, we will need to be a bit more imaginative for older servers :(
Any pre-11 logic added had better mention the compatibility tweak it
required, and that pg_partition_ancestors() could be used to simplify
the filtering a lot for the analyze case. It would be good to add
some test cases to check all the patterns we would need to look after,
for both the VACUUM and ANALYZE cases. Perhaps with vacuumdb
--verbose and a pattern match check of the logs produced, with at
least 2 level of partitioning to check after the case of ANALYZE run
across a rather complex partitioning tree?
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
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-bugs@postgresql.org
Cc: michael@paquier.xyz, horikyota.ntt@gmail.com, henri.chapelle@dbandmore.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables
In-Reply-To: <ZHQ2uUIkRmuY6Glt@paquier.xyz>
* 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