Re: row filtering for logical replication

From: Euler Taveira <euler(at)timbira(dot)com(dot)br>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Suzuki Hironobu <hironobu(at)interdb(dot)jp>
Subject: Re: row filtering for logical replication
Date: 2018-11-01 00:29:59
Message-ID: CAHE3wgiHOdFHcEpm_w5f8vAXiugDmTciTiegNGVktezMbFkkrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Em qua, 28 de fev de 2018 às 20:03, Euler Taveira
<euler(at)timbira(dot)com(dot)br> escreveu:
> The attached patches add support for filtering rows in the publisher.
>
I rebased the patch. I added row filtering for initial
synchronization, pg_dump support and psql support. 0001 removes unused
code. 0002 reduces memory use. 0003 passes only structure member that
is used in create_estate_for_relation. 0004 reuses a parser node for
row filtering. 0005 is the feature. 0006 prints WHERE expression in
psql. 0007 adds pg_dump support. 0008 is only for debug purposes (I'm
not sure some of these messages will be part of the final patch).
0001, 0002, 0003 and 0008 are not mandatory for this feature.

Comments?

--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Attachment Content-Type Size
0001-Remove-unused-atttypmod-column-from-initial-table-sy.patch text/x-patch 2.0 KB
0002-Store-number-of-tuples-in-WalRcvExecResult.patch text/x-patch 3.4 KB
0003-Refactor-function-create_estate_for_relation.patch text/x-patch 2.6 KB
0004-Rename-a-WHERE-node.patch text/x-patch 1.7 KB
0005-Row-filtering-for-logical-replication.patch text/x-patch 40.5 KB
0006-Print-publication-WHERE-condition-in-psql.patch text/x-patch 1.2 KB
0007-Publication-where-condition-support-for-pg_dump.patch text/x-patch 2.8 KB
0008-Debug-for-row-filtering.patch text/x-patch 6.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2018-11-01 00:31:07 Re: INSTALL file
Previous Message Michael Paquier 2018-11-01 00:29:37 Re: INSTALL file