| 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:56:22 |
| Message-ID: | 466EB416.6020506@snaga.org |
| Views: | Whole Thread | Raw Message | 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 | Alvaro Herrera | 2007-06-12 15:07:34 | Re: trace_checkpoint parameter patch |
| Previous Message | Satoshi Nagayasu | 2007-06-12 14:51:32 | trace_checkpoint parameter patch |