Re: [HACKERS] Use sync commit for logical replication apply in TAPtests - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Use sync commit for logical replication apply in TAPtests
Date
Msg-id c330ac16-4814-cbc3-0260-2a914237811e@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Use sync commit for logical replication apply in TAP tests  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Responses Re: [HACKERS] Use sync commit for logical replication apply in TAPtests  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List pgsql-hackers
On 4/18/17 22:25, Petr Jelinek wrote:
> The commit 887227a1c changed the defaults for subscriptions to do async
> commit. But since the tests often wait for disk flush and there is no
> concurrent activity this has increased the amount of time needed for
> each test. So the attached patch changes the subscriptions create in tab
> tests to use sync commit which improves performance there (because we
> also replicate only very few transactions in the tests).

I see only a 1.5% (1s/70s) improvement in the run time of the whole test
suite from this.  Is that what you were expecting?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: [HACKERS] Highly Variable Planning Times
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] dtrace probes