Re: Expose checkpoint start/finish times into SQL. - Mailing list pgsql-patches

From Tom Lane
Subject Re: Expose checkpoint start/finish times into SQL.
Date
Msg-id 25469.1207262074@sss.pgh.pa.us
Whole thread Raw
In response to Re: Expose checkpoint start/finish times into SQL.  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Theo Schlossnagle wrote:
>> First whack at exposing the start and finish checkpoint times into SQL.

> Why is that useful?

Does this implementation even work?  It looks to me like the
globalStats.last_checkpoint_start/done fields will go back to zero the
very next time the bgwriter sends a stats message.  I'm not sure what
a sane behavior would be, but it seems unlikely that that's it.

            regards, tom lane

pgsql-patches by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Expose checkpoint start/finish times into SQL.
Next
From: daveg
Date:
Subject: Re: psql command aliases support