Check replication lag

Поиск
Список
Период
Сортировка
От Sreejith P
Тема Check replication lag
Дата
Msg-id PS2PR02MB28374C3F4C4DE895C746F8CDF34B0@PS2PR02MB2837.apcprd02.prod.outlook.com
обсуждение исходный текст
Ответы Re: Check replication lag  (Thomas Munro <thomas.munro@gmail.com>)
Список 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
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 по дате отправления:

Предыдущее
От: Mariya Rampurawala
Дата:
Сообщение: Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag
Следующее
От: David Gauthier
Дата:
Сообщение: Postgres, High Availability, patching servers sequentially