Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2012-08-25 Thread Bruce Momjian
On Thu, Aug 23, 2012 at 12:40:33PM +0200, Magnus Hagander wrote: > On Wed, Aug 15, 2012 at 5:39 PM, Bruce Momjian wrote: > > On Mon, Aug 15, 2011 at 01:03:35PM +0200, Magnus Hagander wrote: > >> The pg_stat_replication view exposes all the fields in > >> StandbyReplyMessage *except* for the timest

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2012-08-23 Thread Magnus Hagander
On Wed, Aug 15, 2012 at 5:39 PM, Bruce Momjian wrote: > On Mon, Aug 15, 2011 at 01:03:35PM +0200, Magnus Hagander wrote: >> The pg_stat_replication view exposes all the fields in >> StandbyReplyMessage *except* for the timestamp when the message was >> generated. On an active system this is not al

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2012-08-15 Thread Bruce Momjian
On Mon, Aug 15, 2011 at 01:03:35PM +0200, Magnus Hagander wrote: > The pg_stat_replication view exposes all the fields in > StandbyReplyMessage *except* for the timestamp when the message was > generated. On an active system this is not all that interesting, but > on a mostly idle system that allow

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2011-08-16 Thread Magnus Hagander
On Tue, Aug 16, 2011 at 16:00, Simon Riggs wrote: > On Tue, Aug 16, 2011 at 2:25 PM, Robert Haas wrote: >> On Tue, Aug 16, 2011 at 8:54 AM, Simon Riggs wrote: >>> On Tue, Aug 16, 2011 at 10:51 AM, Magnus Hagander >>> wrote: On Mon, Aug 15, 2011 at 13:50, Robert Haas wrote: > On Mon,

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2011-08-16 Thread Simon Riggs
On Tue, Aug 16, 2011 at 2:25 PM, Robert Haas wrote: > On Tue, Aug 16, 2011 at 8:54 AM, Simon Riggs wrote: >> On Tue, Aug 16, 2011 at 10:51 AM, Magnus Hagander >> wrote: >>> On Mon, Aug 15, 2011 at 13:50, Robert Haas wrote: On Mon, Aug 15, 2011 at 7:03 AM, Magnus Hagander wrote: >>>

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2011-08-16 Thread Robert Haas
On Tue, Aug 16, 2011 at 8:54 AM, Simon Riggs wrote: > On Tue, Aug 16, 2011 at 10:51 AM, Magnus Hagander wrote: >> On Mon, Aug 15, 2011 at 13:50, Robert Haas wrote: >>> On Mon, Aug 15, 2011 at 7:03 AM, Magnus Hagander >>> wrote: The pg_stat_replication view exposes all the fields in S

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2011-08-16 Thread Simon Riggs
On Tue, Aug 16, 2011 at 10:51 AM, Magnus Hagander wrote: > On Mon, Aug 15, 2011 at 13:50, Robert Haas wrote: >> On Mon, Aug 15, 2011 at 7:03 AM, Magnus Hagander wrote: >>> The pg_stat_replication view exposes all the fields in >>> StandbyReplyMessage *except* for the timestamp when the message w

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2011-08-16 Thread Magnus Hagander
On Mon, Aug 15, 2011 at 13:50, Robert Haas wrote: > On Mon, Aug 15, 2011 at 7:03 AM, Magnus Hagander wrote: >> The pg_stat_replication view exposes all the fields in >> StandbyReplyMessage *except* for the timestamp when the message was >> generated. On an active system this is not all that inter

Re: [HACKERS] pg_stat_replication vs StandbyReplyMessage

2011-08-15 Thread Robert Haas
On Mon, Aug 15, 2011 at 7:03 AM, Magnus Hagander wrote: > The pg_stat_replication view exposes all the fields in > StandbyReplyMessage *except* for the timestamp when the message was > generated. On an active system this is not all that interesting, but > on a mostly idle system that allows the mo

[HACKERS] pg_stat_replication vs StandbyReplyMessage

2011-08-15 Thread Magnus Hagander
The pg_stat_replication view exposes all the fields in StandbyReplyMessage *except* for the timestamp when the message was generated. On an active system this is not all that interesting, but on a mostly idle system that allows the monitoring to react faster than the timeout that actually kicks the