</indexterm>

<listitem>

<para>

Causes checkpoints to be logged in the server log. Some

statistics about each checkpoint are included in the log messages,

including the number of buffers written and the time spent writing

them.

Causes checkpoints and restartpoints to be logged in the server log.

Some statistics are included in the log messages, including the number

of buffers written and the time spent writing them.

This parameter can only be set in the <filename>postgresql.conf</>

file or on the server command line. The default is off.

</para>

if (restartpoint)

elog(LOG,"restartpoint complete: wrote %d buffers (%.1f%%); "

"sync files=%d, longest=%ld.%03d s, average=%ld.%03d s",

CheckpointStats.ckpt_bufs_written,

(double)CheckpointStats.ckpt_bufs_written*100 /NBuffers,

CheckpointStats.ckpt_segs_added,

CheckpointStats.ckpt_segs_removed,

CheckpointStats.ckpt_segs_recycled,

write_secs,write_usecs /1000,

sync_secs,sync_usecs /1000,

total_secs,total_usecs /1000,

SpinLockRelease(&xlogctl->info_lck);

LWLockRelease(WALInsertLock);

if (log_checkpoints)

{

MemSet(&CheckpointStats,0,sizeof(CheckpointStats));

CheckpointStats.ckpt_start_t=GetCurrentTimestamp();

MemSet(&CheckpointStats,0,sizeof(CheckpointStats));

CheckpointStats.ckpt_start_t=GetCurrentTimestamp();

if (log_checkpoints)

LogCheckpointStart(flags, true);

}

CheckPointGuts(lastCheckPoint.redo,flags);