Re: Log levels for checkpoint/bgwriter monitoring

On Thu, 22 Feb 2007, Jim C. Nasby wrote:

> It would also be extremely useful to make checkpoint stats visible 
> somewhere in the database (presumably via the existing stats 
> mechanism)... I'm thinking just tracking how many pages had to be 
> flushed during a checkpoint would be a good start.

I'm in the middle of testing an updated version of the patch, once I nail 
down exactly what needs to be logged I'd planned to open a discussion on 
which of those things would be best served by pg_stats instead of a log.

I decided specifically to aim for the logs instead for the checkpoint data 
because if you're in a situation where are inserting fast enough that the 
checkpoints are spaced closely together, you'd end up having to poll 
pg_stats all the time for make sure you catch them all, which becomes even 
less efficient than just logging the data.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD