Re: row filtering for logical replication

From: Ajin Cherian <itsajin(at)gmail(dot)com>
To: Peter Smith <smithpb2250(at)gmail(dot)com>
Cc: Greg Nancarrow <gregn4422(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Euler Taveira <euler(at)eulerto(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Önder Kalacı <onderkalaci(at)gmail(dot)com>, japin <japinli(at)hotmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, David Steele <david(at)pgmasters(dot)net>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: row filtering for logical replication
Date: 2021-11-02 11:44:05
Message-ID: CAFPTHDZt+KH89+=UdxkNnLDPWzXRBGr45stC1XrfJ7OnQfOuzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here's a rebase of the first 4 patches of the row-filter patch. Some
issues still remain:

1. the following changes for adding OptWhereClause to the
PublicationObjSpec has not been added
as the test cases for this has not been yet rebased:

PublicationObjSpec:
...
+ TABLE relation_expr OptWhereClause
...
+ | ColId OptWhereClause
...
+ | ColId indirection OptWhereClause
...
+ | extended_relation_expr OptWhereClause

2. Changes made to AlterPublicationTables() undid changes that were as
part of the schema publication patch. This needs to be resolved
with the correct approach.

The patch 0005 and 0006 has not yet been rebased but will be updated
in a few days.

regards,
Ajin Cherian

Attachment Content-Type Size
v35-0002-PS-Add-tab-auto-complete-support-for-the-Row-Fil.patch application/octet-stream 2.4 KB
v35-0001-Row-filter-for-logical-replication.patch application/octet-stream 71.2 KB
v35-0003-PS-ExprState-cache-modifications.patch application/octet-stream 11.3 KB
v35-0004-PS-Row-filter-validation-of-replica-identity.patch application/octet-stream 20.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeevan Ladhe 2021-11-02 11:52:29 Re: refactoring basebackup.c
Previous Message gkokolatos 2021-11-02 11:36:49 Re: Teach pg_receivewal to use lz4 compression