Re: Should bgwriter log checkpoint start/end? - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Should bgwriter log checkpoint start/end?
Date
Msg-id 87pt34rlwb.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Should bgwriter log checkpoint start/end?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:

> For now, DEBUG1. Longer term, we need to discuss a "performance log" or
> some place to put regularly collected performance statistics, rather
> than site specific ones.

As a data point, with Oracle we often found it useful that Oracle logs all
checkpoints. One log entry every few minutes really isn't an excessive amount
of logging, even if it is a routine non-error condition.

I would suggest a higher level, INFO or NOTICE.

-- 
greg



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: src/timezone/pgtz __imp__my_exec_path
Next
From: Tom Lane
Date:
Subject: Re: 8.0b4: COMMIT outside of a transaction echoes ROLLBACK