Re: Question regarding logical replication

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Weiping Qu <qu(at)informatik(dot)uni-kl(dot)de>
Cc: Alvaro Aguayo Garcia-Rada <aaguayo(at)opensysperu(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question regarding logical replication
Date: 2017-10-27 09:53:53
Message-ID: CA+bJJbz=sJsbMMR_5qWoNKdr4Nag5BJcAJ-=nVhs2Kc9gSkf2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 26, 2017 at 10:20 PM, Weiping Qu <qu(at)informatik(dot)uni-kl(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Weiping Qu 2017-10-27 10:04:30 Re: Question regarding logical replication
Previous Message John R Pierce 2017-10-27 07:51:44 Re: Can't build ODBC -- odbc_config not found