Re: Expose checkpoint start/finish times into SQL.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Expose checkpoint start/finish times into SQL.
Дата
Msg-id 7568.1207293268@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Expose checkpoint start/finish times into SQL.  (Greg Smith <gsmith@gregsmith.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Expose checkpoint start/finish times into SQL.
Следующее
От: "Ceschia, Marcello"
Дата:
Сообщение: Re: Re: [BUGS] BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data