| From: | Erik Rijkers <er(at)xs4all(dot)nl> |
|---|---|
| To: | Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com> |
| Cc: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Subject: | Re: logical replication - still unstable after all these months |
| Date: | 2017-05-31 14:20:00 |
| Message-ID: | cf6a7c956f9346667bbbdaab64b1b562@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2017-05-31 11:16, Petr Jelinek wrote:
[...]
> Thanks to Mark's offer I was able to study the issue as it happened and
> found the cause of this.
>
> [0001-Improve-handover-logic-between-sync-and-apply-worker.patch]
This looks good:
-- out_20170531_1141.txt
100 -- pgbench -c 90 -j 8 -T 60 -P 12 -n -- scale 25
100 -- All is well.
So this is 100x a 1-minute test with 100x success. (This on the most
fastidious machine (slow disks, meagre specs) that used to give 15%
failures)
I'll let it run for a couple of days with varying params (and on varying
hardware) but it definitely does look as if you fixed it.
Thanks!
Erik Rijkers
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-05-31 14:49:05 | Re: TAP backpatching policy |
| Previous Message | Kevin Grittner | 2017-05-31 14:14:17 | Re: transition table behavior with inheritance appears broken (was: Declarative partitioning - another take) |