Search Postgresql Archives

Re: NOTIFY command impact

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: NOTIFY command impact
From: Benoit Lobréau <benoit.lobreau@xxxxxxxxx>
Date: Thu, 23 Feb 2017 16:23:30 +0100
Cc: Rob Brucks <rob.brucks@xxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, François Beaulieu <frank@xxxxxxxxx>, Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAKFQuwaGuMhUWoAnKU+0=QuaeHv5hQuyGtgPxVVb4HbkTnaYwg@mail.gmail.com>
References: <52ADE82A-A208-40F2-B061-3A70ADF0FE1E@TZoNE.ORG> <17622.1487798346@sss.pgh.pa.us> <E0744EE6-DFCA-4E6B-A382-EDD52846D55C@rackspace.com> <CAKFQuwaGuMhUWoAnKU+0=QuaeHv5hQuyGtgPxVVb4HbkTnaYwg@mail.gmail.com>

Hi,

I might have missed something.

This should be enough to solve the problem no ?

SELECT

CASE

WHEN pg_last_xlog_receive_location() = pg_last_xlog_replay_location() THEN 0

ELSE EXTRACT (EPOCH FROM now() - pg_last_xact_replay_timestamp())::INTEGER

END

AS replication_lag;

Benoit.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: NOTIFY command impact
  - From: Rob Brucks

References:
- Re: NOTIFY command impact
  - From: François Beaulieu
- Re: NOTIFY command impact
  - From: Tom Lane
- Re: NOTIFY command impact
  - From: Rob Brucks
- Re: NOTIFY command impact
  - From: David G. Johnston

Prev by Date: Re: Foreign key references a unique index instead of a primary key
Next by Date: Re: Move rows from one database to other
Previous by thread: Re: NOTIFY command impact
Next by thread: Re: NOTIFY command impact
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux