Should bgwriter log checkpoint start/end?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Should bgwriter log checkpoint start/end?
Date: 2004-10-26 22:44:18
Message-ID: 14278.1098830658@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2004-10-26 23:39:46 Re: DBT-3 Query 2 EXPLAIN ANALYZE differences
Previous Message Reini Urban 2004-10-26 22:07:47 Re: rmtree() failure on Windows