Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter
Дата
Msg-id CA+U5nMKrUG5OB8SmMEHs-YqGFcbJcS0wBSwaRn2HKiikm_HBiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Publish checkpoint timing and sync files summary data to pg_stat_bgwriter  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Thu, Jan 19, 2012 at 3:52 PM, Robert Haas <robertmhaas@gmail.com> wrote:

> And, it doesn't seem like it's necessarily going to safe me a whole
> lot either, because if it turns out that my sync phases are long, the
> first question out of my mouth is going to be "what percentage of my
> total sync time is accounted for by the longest sync?".  And so right
> there I'm back to the logs.

It seems clear that the purpose of this is to quickly and easily
decide whether there is a potential problem.

If you decide there is a potential problem, you may wish to look at
more detailed information.

So there is a huge time saving from avoiding the need to look at the
detail when its unnecessary and possibly not even enabled.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Simulating Clog Contention
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Inline Extension