Hi. I've had experience with both BDR & pglogical. For each replication slot, postgres saves a LSN which points to the
lastxlog entry read by the client. When a client does not reads xlog, for example, if it cannot connect to the server,
thenthe distance between such LSN(pg_replication_slots.restart_lsn) and the current xlog
location(pg_current_xlog_insert_location())will enlarge over the time. Not sure about the following, but postgres will
notclear old xlog entries which are still pending to be read on any replication slot. Such situation may also happen,
inlower degree, if the client cannot read WAL as fast as it's produced. Anyhow, what will happen is xlog will grow more
andmore. However, that will probably not impact performance, as xlog is written anyway. But if you don't have enough
freespace, you could get your partition full of xlog.
Regards,
Alvaro Aguayo
Operations Manager
Open Comb Systems E.I.R.L.
Office: (+51-1) 3377813 | Mobile: (+51) 995540103 | (+51) 954183248
Web: www.ocs.pe
----- Original Message -----
From: "Weiping Qu" <qu@informatik.uni-kl.de>
To: "PostgreSql-general" <pgsql-general@postgresql.org>
Sent: Thursday, 26 October, 2017 14:07:54
Subject: [GENERAL] Question regarding logical replication
Dear postgresql community,
I have a question regarding understanding the implementation logic
behind logical replication.
Assume a replication slot created on the master node, will more and more
data get piled up in the slot and the size of replication slot
continuously increase if there is no slave reading/dequeuing data out of
this slot or very slowly, thus incurring high I/Os and slow down the
transaction throughput?
Looking forward to your explanation.
Kindly review and please share your comments on this matter.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
