Re: logical replication empty transactions

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: logical replication empty transactions
Дата
Msg-id CAH503wBXk18nWUQYbAeLuJY1jSsEiLUyF5+ubi2v4AaAjbvCHg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: logical replication empty transactions  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: logical replication empty transactions  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Back-patching -Wno-format-truncation.
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: [PATCH] kNN for btree