Re: Should bgwriter log checkpoint start/end?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Should bgwriter log checkpoint start/end?
Date: 2004-10-27 19:39:16
Message-ID: 87pt34rlwb.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-10-27 20:21:53 Re: 8.0b4: COMMIT outside of a transaction echoes ROLLBACK
Previous Message Bruce Momjian 2004-10-27 19:13:44 Re: [HACKERS] src/timezone/pgtz __imp__my_exec_path