Thanks, Francisco. From the plots we got the same feeling, cache reads
with little lags and high cache hits really don't put extra burden on
the original write throughput for OLTP transactions. And log-based is
the most efficient and harm-less one as compared to trigger-based and
timestamp base
On Fri, Oct 27, 2017 at 12:04 PM, Weiping Qu wrote:
> That's a good point and we haven't accounted for disk caching.
> Is there any way to confirm this fact in PostgreSQL?
I doubt, as it names indicates cache should be hidden from the db server.
You could monitor the machine with varying lags an
That's a good point and we haven't accounted for disk caching.
Is there any way to confirm this fact in PostgreSQL?
Weiping
On 27.10.2017 11:53, Francisco Olarte wrote:
On Thu, Oct 26, 2017 at 10:20 PM, Weiping Qu wrote:
However, the plots showed different trend (currently I don't have plot
On Thu, Oct 26, 2017 at 10:20 PM, Weiping Qu wrote:
> However, the plots showed different trend (currently I don't have plots on
> my laptop) which shows that the more frequently are the CDC processes
> reading from logical slots, the less overhead is incurred over PostgreSQL,
> which leads to hi
ql-general"
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
rds,
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"
To: "PostgreSql-general"
Sent: Thursday, 26 October, 2017 14:07:54
Subjec
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
