Replica and transaction - Mailing list pgsql-admin

From kaido vaikla
Subject Replica and transaction
Date
Msg-id CA+427g-91rw4Rb=+Hd2Y4jaqVMK=LViN2Pun=4TV+KhqgBi8_Q@mail.gmail.com
Whole thread Raw
Responses Re: Replica and transaction
List pgsql-admin
Hi,

I found a statement:

Long-running transactions can cause replication lag because the changes made by these transactions are not replicated until the transaction is committed.
(https://www.percona.com/blog/replication-lag-in-postgresql/)


It means:
change made by transaction is not replicated until the transaction is committed?

And for example
time0: wal on primary
time1: tx1 begin
time2: tx2 begin
time3: tx2 rollback
time4: tx3 begin
time5: tx3 commit
time6: tx1 commit
time7: walsender sends tx1, tx3 to replica, tx2 skipped because rollback
?

br
Kaido

pgsql-admin by date:

Previous
From: rams nalabolu
Date:
Subject: Re: My Pgbackrest Backups Take Up Too Much Space
Next
From: Ron Johnson
Date:
Subject: Feature Request: multithreaded reindexdb --concurrently of a single table