Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: henri(dot)chapelle(at)dbandmore(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17942: vacuumdb doesn't populate extended statistics on partitioned tables
Date: 2023-05-25 07:45:50
Message-ID: ZG8SLtCX0erW5Di7@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, May 25, 2023 at 01:07:59PM +0900, Kyotaro Horiguchi wrote:
> ANALYZE processes inhertance parents. By a quick search, I found
> that commit 3c3bb99330 modified get_rel_oids (which has now been
> relocated to get_all_vacuum_rels) to include
> RELKIND_PARTITIONED_TABLE. However, it seems like it overlooked
> updating the same in vacuumdb.c. This dates back to 10.

You cannot do that, because this would make a single run of vacuumdb
process more than once each partition. Am I missing something?
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2023-05-25 14:04:39 BUG #17944: Partial index on boolean field is not picked when using = while the index is created with is
Previous Message Hans Buschmann 2023-05-25 07:30:58 AW: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore