Postgres Pro
Downloads
Home   >   mailing lists

Check replication lag - Mailing list pgsql-general

From Sreejith P
Subject Check replication lag
Date
Msg-id PS2PR02MB28374C3F4C4DE895C746F8CDF34B0@PS2PR02MB2837.apcprd02.prod.outlook.com
Whole thread Raw
Responses Re: Check replication lag  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-general
Tree view

Hi,

 

Am using SELECT (now() - pg_last_xact_replay_timestamp()) < '1’) min for identifying replication lag. Is there any better option available in postgres 10.

 

IN SYNC mode of replication what would be the impact on Master DB server in terms of over all performance  ?

 

 

 

 

 

Thanks

Sreejith.


 

Solutions for Care Anywhere

dWise HealthCare IT Solutions Pvt. Ltd. | www.lifetrenz.com
Disclaimer: The information and attachments contained in this email are intended for exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender immediately and destroy all copies of this message and any attachments. The views expressed in this email are, unless otherwise stated, those of the author and not those of dWise HealthCare IT Solutions or its management.

pgsql-general by date:

Previous
From: Mariya Rampurawala
Date:
Subject: Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag
Next
From: David Gauthier
Date:
Subject: Postgres, High Availability, patching servers sequentially