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 <http://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.

Reply via email to