Re: [GENERAL] Hot Standby Lag Calculation

2011-08-05 Thread mark
>From: pgsql-general-ow...@postgresql.org On Behalf Of Sam Nelson >Sent: Wednesday, August 03, 2011 11:03 AM >To: pgsql-general >Subject: [GENERAL] Hot Standby Lag Calculation >Hi, List, >We're trying to calculate the amount of time that a Hot Standby slave is >lagg

[GENERAL] Hot Standby Lag Calculation

2011-08-03 Thread Sam Nelson
Hi, List, We're trying to calculate the amount of time that a Hot Standby slave is lagging behind its master, and our results look wrong (average of 7 seconds, with some over 1 minute), so we were thinking that we're probably calculating it wrong. We're currently just using the timestamps from ls