Re: logical replication empty transactions - Mailing list pgsql-hackers

From Euler Taveira
Subject Re: logical replication empty transactions
Date
Msg-id CAH503wBXk18nWUQYbAeLuJY1jSsEiLUyF5+ubi2v4AaAjbvCHg@mail.gmail.com
Whole thread Raw
In response to Re: logical replication empty transactions  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: logical replication empty transactions  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On Tue, 3 Mar 2020 at 05:24, Amit Kapila <amit.kapila16@gmail.com> wrote:

Another idea could be that we stream the transaction after some
threshold number (say 100 or anything we think is reasonable) of empty
xacts.  This will reduce the traffic without tinkering with the core
design too much.


Amit, I suggest an interval to control this setting. Time is something we have control; transactions aren't (depending on workload). pg_stat_replication query interval usually is not milliseconds, however, you can execute thousands of transactions in a second. If we agree on that idea I can add it to the patch.


Regards,
 

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

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Back-patching -Wno-format-truncation.
Next
From: Peter Geoghegan
Date:
Subject: Re: [PATCH] kNN for btree