Re: [GENERAL] Calculating Replication Lag - units

2012-06-26 Thread David Kerr
On Tue, Jun 26, 2012 at 09:13:44AM -0700, Steve Crawford wrote: - On 06/26/2012 08:16 AM, David Kerr wrote: - >On 06/26/2012 05:11 AM, Stuart Bishop wrote: - >>On Tue, Jun 26, 2012 at 6:21 AM, David Kerr wrote: - >>>On Mon, Jun 25, 2012 at 02:17:22PM -0700, Steve Crawford wrote: - >>>- On 06/25/20

Re: [GENERAL] Calculating Replication Lag - units

2012-06-26 Thread Steve Crawford
On 06/26/2012 08:16 AM, David Kerr wrote: On 06/26/2012 05:11 AM, Stuart Bishop wrote: On Tue, Jun 26, 2012 at 6:21 AM, David Kerr wrote: On Mon, Jun 25, 2012 at 02:17:22PM -0700, Steve Crawford wrote: - On 06/25/2012 01:17 PM, David Kerr wrote: ->Howdy, -> ->When calculating Replication lag,

Re: [GENERAL] Calculating Replication Lag - units

2012-06-26 Thread David Kerr
On 06/26/2012 05:11 AM, Stuart Bishop wrote: On Tue, Jun 26, 2012 at 6:21 AM, David Kerr wrote: On Mon, Jun 25, 2012 at 02:17:22PM -0700, Steve Crawford wrote: - On 06/25/2012 01:17 PM, David Kerr wrote: ->Howdy, -> ->When calculating Replication lag, I know that we have to compare the ->pg_cur

Re: [GENERAL] Calculating Replication Lag - units

2012-06-26 Thread David Kerr
On 06/26/2012 05:11 AM, Stuart Bishop wrote: On Tue, Jun 26, 2012 at 6:21 AM, David Kerr wrote: On Mon, Jun 25, 2012 at 02:17:22PM -0700, Steve Crawford wrote: - On 06/25/2012 01:17 PM, David Kerr wrote: ->Howdy, -> ->When calculating Replication lag, I know that we have to compare the ->pg_cur

Re: [GENERAL] Calculating Replication Lag - units

2012-06-26 Thread Stuart Bishop
On Tue, Jun 26, 2012 at 6:21 AM, David Kerr wrote: > On Mon, Jun 25, 2012 at 02:17:22PM -0700, Steve Crawford wrote: > - On 06/25/2012 01:17 PM, David Kerr wrote: > - >Howdy, > - > > - >When calculating Replication lag, I know that we have to compare the > - >pg_current_xlog_location > - >to pg_la

Re: [GENERAL] Calculating Replication Lag - units

2012-06-25 Thread David Kerr
On 6/25/2012 9:55 PM, Raghavendra wrote: On Tue, Jun 26, 2012 at 1:47 AM, David Kerr mailto:d...@mr-paradox.net>> wrote: Howdy, When calculating Replication lag, I know that we have to compare the pg_current_xlog_location to pg_last_xlog_receive_location, etc. but what I'm tryi

Re: [GENERAL] Calculating Replication Lag - units

2012-06-25 Thread Raghavendra
On Tue, Jun 26, 2012 at 1:47 AM, David Kerr wrote: > Howdy, > > When calculating Replication lag, I know that we have to compare the > pg_current_xlog_location > to pg_last_xlog_receive_location, etc. but what I'm trying to figure out > is what are > the units that I'm left with after the calcula

Re: [GENERAL] Calculating Replication Lag - units

2012-06-25 Thread David Kerr
On Mon, Jun 25, 2012 at 02:17:22PM -0700, Steve Crawford wrote: - On 06/25/2012 01:17 PM, David Kerr wrote: - >Howdy, - > - >When calculating Replication lag, I know that we have to compare the - >pg_current_xlog_location - >to pg_last_xlog_receive_location, etc. but what I'm trying to figure out

Re: [GENERAL] Calculating Replication Lag - units

2012-06-25 Thread Steve Crawford
On 06/25/2012 01:17 PM, David Kerr wrote: Howdy, When calculating Replication lag, I know that we have to compare the pg_current_xlog_location to pg_last_xlog_receive_location, etc. but what I'm trying to figure out is what are the units that I'm left with after the calculation. (i.e., does t

[GENERAL] Calculating Replication Lag - units

2012-06-25 Thread David Kerr
Howdy, When calculating Replication lag, I know that we have to compare the pg_current_xlog_location to pg_last_xlog_receive_location, etc. but what I'm trying to figure out is what are the units that I'm left with after the calculation. (i.e., does the xlog_location imply some time value?) He