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 7568.1207293268@sss.pgh.pa.us
Whole thread Raw
In response to Re: Expose checkpoint start/finish times into SQL.  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: Expose checkpoint start/finish times into SQL.  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Expose checkpoint start/finish times into SQL.  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-patches
Greg Smith <gsmith@gregsmith.com> writes:
> ... If they'd have noticed it while the server was up, perhaps because the
> "last checkpoint" value hadn't changed in a long time (which seems like it
> might be available via stats even if, as you say, the background writer is
> out of its mind at that point), they could have done such a kill and
> collected some actual useful information here.  That's the theory at
> least.

Well, mebbe, but that still seems to require a lot of custom monitoring
infrastructure that is not present in this patch, and furthermore that
this patch doesn't especially aid the development of.

            regards, tom lane

pgsql-patches by date:

Previous
From: Greg Smith
Date:
Subject: Re: Expose checkpoint start/finish times into SQL.
Next
From: "Ceschia, Marcello"
Date:
Subject: Re: Re: [BUGS] BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data