Re: [HACKERS] Infrastructure changes for recovery - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: [HACKERS] Infrastructure changes for recovery
Date
Msg-id 20080912181421.GI8854@alvh.no-ip.org
Whole thread Raw
In response to Re: [HACKERS] Infrastructure changes for recovery  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: [HACKERS] Infrastructure changes for recovery  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-patches
Simon Riggs wrote:

> --- 5716,5725 ----
>                           CheckpointStats.ckpt_sync_end_t,
>                           &sync_secs, &sync_usecs);
>
> !     elog(LOG, "%s complete: wrote %d buffers (%.1f%%); "
>            "%d transaction log file(s) added, %d removed, %d recycled; "
>            "write=%ld.%03d s, sync=%ld.%03d s, total=%ld.%03d s",
> +          (checkpoint ? "  checkpoint" : "restartpoint"),
>            CheckpointStats.ckpt_bufs_written,
>            (double) CheckpointStats.ckpt_bufs_written * 100 / NBuffers,
>            CheckpointStats.ckpt_segs_added,

Very minor nit: this really needs a rework.  It is relatively OK in the
previous code, but it was already stuffing too much in a single message.
Maybe

ereport(LOG,
(errmsg(checkpoint ? "checkpoint complete" : "restartpoint complete"),
errdetail("Wrote %d buffers (%.1f%%); "
    "%d transaction log file(s) added, %d removed, %d recycled; "
    "write=%ld.%03d s, sync=%ld.%03d s, total=%ld.%03d s.",
    ...
)))

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-patches by date:

Previous
From: "Alex Hunsaker"
Date:
Subject: Re: hash index improving v3
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Infrastructure changes for recovery