Regarding logical replication issues with PostgreSQL versions 16 and above

From: yexiu-glory <yexiu-glory(at)qq(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Regarding logical replication issues with PostgreSQL versions 16 and above
Date: 2025-07-18 11:08:48
Message-ID: tencent_2EDF6F264A6F6C92BE540FC63078544EDF08@qq.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm facing a problem here: our business requires logical data replication to other departments, but at the same time, sensitive fields need to be filtered out. Therefore, we used the column filtering function when creating logical replication. If we use `alter table table1 replica identity default;`, there is no issue at all. However, when encountering new business scenarios, we need to use the CSI columnar index function. Under the default setting, the synchronization delay of the CSI columnar index is severe. Therefore, we need to use `alter table table1 replica identity full;` so that the CSI columnar index can perform data comparison and only convert changed data when receiving data, thereby speeding up the data conversion efficiency of the CSI columnar index. However, after using `alter table table1 replica identity full;`, updating the table will result in an error. ERROR: cannot update table "table1" DETAIL: The column list used by the publication does not cover the replica identity. So, is there any solution to this problem, or is there a better approach to accelerate the conversion efficiency of the CSI columnar index.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pierre Barre 2025-07-18 12:31:05 Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance
Previous Message Pierre Barre 2025-07-18 10:57:39 Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance