CHECKPOINT - Force transaction log checkpoint
SYNOPSIS
CHECKPOINT
DESCRIPTION
Write-Ahead Logging (WAL) puts a checkpoint in the trans
action log every so often. (To adjust the automatic check
point interval, see the run-time configuration options
CHECKPOINT_SEGMENTS and CHECKPOINT_TIMEOUT.) The CHECK
POINT command forces an immediate checkpoint when the com
mand is issued, without waiting for a scheduled check
point.
A checkpoint is a point in the transaction log sequence at
which all data files have been updated to reflect the
information in the log. All data files will be flushed to
disk. Refer to the PostgreSQL Administrator's Guide for
more information about the WAL system.
Only superusers may call CHECKPOINT. The command is not
intended for use during normal operation.
SEE ALSO
PostgreSQL Administrator's Guide
COMPATIBILITY
The CHECKPOINT command is a PostgreSQL language extension.
Man(1) output converted with
man2html