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 |
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 |