Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group