trace_checkpoint parameter patch

From: Satoshi Nagayasu <snaga(at)snaga(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: trace_checkpoint parameter patch
Date: 2007-06-12 14:51:32
Message-ID: 466EB2F4.2030601@snaga.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi all,

Here is a brand new patch to log a checkpointing load information
to tune the bgwriter parameter.

When you enable trace_checkpoint parameter and process
the checkpoint, the bgwriter logs the number of
flushed buffer pages and the elapsed time.

-----------------------------------------------------------
{61}snaga(at)artemis:~/pgsql-snapshot% ./bin/psql -c 'checkpoint' pgbench
LOG: CheckPoint: 1522/3072 buffer(s) flushed. CPU 0.03s/0.00u sec elapsed 1.57 sec
CHECKPOINT
{62}snaga(at)artemis:~/pgsql-snapshot%
-----------------------------------------------------------

I think this information is useful to configure
the bgwriter parameter to reduce the performance impact
of the checkpointing.

Any suggestion or comments?
--
NAGAYASU Satoshi <snaga(at)snaga(dot)org>

Attachment Content-Type Size
trace_checkpoint.diff text/plain 6.9 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Satoshi Nagayasu 2007-06-12 14:56:22 trace_checkpoint parameter patch
Previous Message Gregory Stark 2007-06-12 14:18:22 Re: Two aesthetic bugs in the 1-byte packed varlena code