Lag clarification with Sync Replication

From: Raj kumar <rajkumar820999(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Lag clarification with Sync Replication
Date: 2020-05-22 04:36:08
Message-ID: CACxU--UqAsOuj+zViH3sjra-P6Z+gps7aOs2845F+_ehALF5yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have made a synchronous replication setup with PG12.
During data loading of 200 gig in master node, I found that there is a lag
that it shows on the slave. But, ideally for sync replication, lag should
be always 0 right.
Because commit never happens in master before updating the slave.
log_delay
------------
871.549671
(1 row) log_delay
------------
871.557246
(1 row) log_delay
-----------
0
(1 row) log_delay
-----------
0
(1 row)

*Query Used for checking Standby Replication Lag:*
psql -d perfbench -p 5432 -c "SELECT CASE WHEN pg_last_wal_receive_lsn() =
pg_last_wal_replay_lsn()
THEN 0
ELSE EXTRACT (EPOCH FROM now() - pg_last_xact_replay_timestamp())
END AS log_delay;"

*Setting Used in PG12*

cat postgresql.conf |grep synchronous_

synchronous_commit = remote_write # synchronization level;

synchronous_standby_names = 'ANY 1 (standby1,standby2)' # standby
servers that provide sync rep

cat postgresql.conf |grep primary_conn

primary_conninfo = 'user=edbrepl host= 10.12.11.101 port=5432
application_name=standby1 '

Thanks,
Raj Kumar

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message postgann2020 s 2020-05-22 06:41:10 Suggestion to improve query performance of data validation in proc.
Previous Message David G. Johnston 2020-05-21 14:59:57 Re: Suggestion on column cast automatically to data type