Re: regular logging of checkpoint progress - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: regular logging of checkpoint progress
Date
Msg-id CAHGQGwHDx-ru_JyuX1y_WxxvavJhBGRLWEQjYN1yV0tw+XqsiQ@mail.gmail.com
Whole thread Raw
In response to Re: regular logging of checkpoint progress  (Andy Colson <andy@squeakycode.net>)
List pgsql-hackers
On Tue, Sep 6, 2011 at 3:02 AM, Andy Colson <andy@squeakycode.net> wrote:
> Several people thought a view or some-non-log option would be better.

+1

> Tomas
> replied "but I need to go back in time to post diagnose a problem", and I
> saw no replies to that.

You can go back in time if you periodically collect the information from a view
or some-non-log. Some tools (e.g., pg_statsinfo, Oracle statspack) have already
been doing that.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: memory-related bugs
Next
From: Andy Colson
Date:
Subject: REVIEW proposal: a validator for configuration files