| From: | Peter Smith <smithpb2250(at)gmail(dot)com> |
|---|---|
| To: | vignesh C <vignesh21(at)gmail(dot)com> |
| Cc: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, "kuroda(dot)hayato(at)fujitsu(dot)com" <kuroda(dot)hayato(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Handle infinite recursion in logical replication setup |
| Date: | 2022-04-07 04:09:23 |
| Message-ID: | CAHut+PssxTA=qYb1xW1=BjjLtLJkFpLM6NsR8M+jA-8JdGEdcQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
FYI, here is a test script that is using the current patch (v6) to
demonstrate a way to share table data between different numbers of
nodes (up to 5 of them here).
The script starts off with just 2-way sharing (nodes N1, N2),
then expands to 3-way sharing (nodes N1, N2, N3),
then 4-way sharing (nodes N1, N2, N3, N4),
then 5-way sharing (nodes N1, N2, N3, N4, N5).
As an extra complication, for this test, all 5 nodes have different
initial table data, which gets replicated to the others whenever each
new node joins the existing share group.
PSA.
------
Kind Regards,
Peter Smith.
Fujitsu Australia
| Attachment | Content-Type | Size |
|---|---|---|
| test_output.txt | text/plain | 10.7 KB |
| test.sh | text/x-sh | 9.6 KB |
| N2.log | application/octet-stream | 8.9 KB |
| N1.log | application/octet-stream | 12.0 KB |
| N5.log | application/octet-stream | 11.1 KB |
| N4.log | application/octet-stream | 10.3 KB |
| N3.log | application/octet-stream | 9.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2022-04-07 04:09:41 | Re: Add proper planner support for ORDER BY / DISTINCT aggregates |
| Previous Message | David Rowley | 2022-04-07 04:05:19 | Re: Speed up transaction completion faster after many relations are accessed in a transaction |