From: | Sreejith P <sreejith(at)lifetrenz(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Check replication lag |
Date: | 2020-08-05 19:01:54 |
Message-ID: | PS2PR02MB28374C3F4C4DE895C746F8CDF34B0@PS2PR02MB2837.apcprd02.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David Gauthier | 2020-08-05 21:36:54 | Postgres, High Availability, patching servers sequentially |
Previous Message | Mariya Rampurawala | 2020-08-05 18:36:15 | Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag |