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

From Tom Lane
Subject Should bgwriter log checkpoint start/end?
Date
Msg-id 14278.1098830658@sss.pgh.pa.us
Whole thread Raw
Responses Re: Should bgwriter log checkpoint start/end?
List pgsql-hackers
In previous releases it was possible to observe whether an automatic
checkpoint was in progress by looking to see if there was a postmaster
child process doing one.  In 8.0 this will not work because the bgwriter
is always there.  I am thinking that for tasks such as performance
debugging it would be a good idea if the bgwriter could emit postmaster
log messages at start and end of a checkpoint.  However, this should
probably not happen at the default LOG level since it would clutter the
logs with perfectly routine messages.  Any opinions about what elog
level to use for this?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Reini Urban
Date:
Subject: Re: rmtree() failure on Windows
Next
From: Josh Berkus
Date:
Subject: Re: DBT-3 Query 2 EXPLAIN ANALYZE differences