Proposal: Cascade REPLICA IDENTITY changes to leaf partitions

[grantzhou]

--- As of 2026-01-27T07:28:40.000Z ---

Chao Li identified a bug where the indisreplident flag of indexes on child partitions is lost after index rebuild operations. This flag is crucial for replica identity functionality in PostgreSQL partitioning. Michael Paquier confirmed this appears to be a legitimate problem that needs addressing. Chao Li has started a separate discussion thread specifically focused on this bug, providing detailed analysis and proposing a fix. The issue affects the proper functioning of replica identity settings on partitioned tables, which is important for logical replication and change data capture scenarios. The bug discovery emerged during work on cascading replica identity changes to leaf partitions, highlighting the complexity of maintaining consistent replica identity behavior across partition hierarchies.

Chao Li发现了一个bug，即在索引重建操作后，子分区上索引的indisreplident标志会丢失。这个标志对于PostgreSQL分区中的replica identity功能至关重要。Michael Paquier确认这看起来是一个需要解决的合法问题。Chao Li已经启动了一个专门针对此bug的单独讨论线程，提供了详细分析并提出了修复方案。这个问题影响了分区表上replica identity设置的正常功能，这对于逻辑复制和变更数据捕获场景很重要。这个bug的发现出现在将replica identity更改级联到叶子分区的工作过程中，突显了在分区层次结构中维持一致的replica identity行为的复杂性。

participants - 参与者:

• 9erthalion6@gmail.com
• alvherre@kurilemu.de
• amit.kapila16@gmail.com
• euler@eulerto.com
• houzj.fnst@fujitsu.com
• li.evan.chao@gmail.com
• michael@paquier.xyz
• peter@eisentraut.org
• robertmhaas@gmail.com