PATCH: regular logging of checkpoint progress

From: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: PATCH: regular logging of checkpoint progress
Date: 2011-08-25 20:57:11
Message-ID: 10c944c3d316b1e791010313b1341c51.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I'd like to propose a small patch that allows better checkpoint progress
monitoring. The patch is quite simple - it adds a new integer GUC
"checkpoint_update_limit" and every time checkpoint writes this number of
buffers, it does two things:

(a) logs a "checkpoint status" message into the server log, with info
about total number of buffers to write, number of already written buffers,
current and average write speed and estimate of remaining time

(b) sends bgwriter stats (so that the buffers_checkpoint is updated)

I believe this will make checkpoint tuning easier, especially with large
shared bufferers and large when there's other write activity (so that it's
difficult to see checkpoint I/O).

The default value (0) means this continuous logging is disabled.

Tomas

Attachment Content-Type Size
checkpoint-stats-update.diff text/plain 6.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-08-25 21:12:59 Re: A couple of issues with psql variable substitution
Previous Message hubert depesz lubaczewski 2011-08-25 20:53:18 Re: [GENERAL] pg_upgrade problem