Re: [HACKERS] logical replication - still unstable after all thesemonths - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: [HACKERS] logical replication - still unstable after all thesemonths
Date
Msg-id cf6a7c956f9346667bbbdaab64b1b562@xs4all.nl
Whole thread Raw
In response to Re: [HACKERS] logical replication - still unstable after all thesemonths  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Responses Re: [HACKERS] logical replication - still unstable after all thesemonths  (Erik Rijkers <er@xs4all.nl>)
List 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



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: [HACKERS] Re: transition table behavior with inheritance appears broken (was:Declarative partitioning - another take)
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] TAP backpatching policy