Re: [GENERAL] Question regarding logical replication - Mailing list pgsql-general

From Francisco Olarte
Subject Re: [GENERAL] Question regarding logical replication
Date
Msg-id CA+bJJbz=sJsbMMR_5qWoNKdr4Nag5BJcAJ-=nVhs2Kc9gSkf2A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Question regarding logical replication  (Weiping Qu <qu@informatik.uni-kl.de>)
Responses Re: [GENERAL] Question regarding logical replication  (Weiping Qu <qu@informatik.uni-kl.de>)
List pgsql-general
On Thu, Oct 26, 2017 at 10:20 PM, Weiping Qu <qu@informatik.uni-kl.de> 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 higher throughput.

Have you accounted for disk caching? Your CDC may be getting log from
the cache when going with little lag but being forced to read from
disk (make the server do it ) when it falls behind.

Francisco Olarte.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Can't build ODBC -- odbc_config not found
Next
From: Weiping Qu
Date:
Subject: Re: [GENERAL] Question regarding logical replication