CHECKPOINT SQL - Language Statements CHECKPOINT Forces a checkpoint in the transaction log 2001-01-23 CHECKPOINT 20001-01-23 None 1999-06-11 CHECKPOINT This signifies that a checkpoint has been placed into the transaction log. 2001-01-23 Write-Ahead Logging (WAL) puts a checkpoint in the log every 300 seconds by default. (This may be changed by the parameter CHECKPOINT_TIMEOUT in postgresql.conf.) The CHECKPOINT command forces a checkpoint at the point at which the command is issued. The next automatic checkpoint will happen the default time after the forced checkpoint. 1999-06-11 Use of the CHECKPOINT command is restricted to users with administrative access. To force a checkpoint in the transaction log: CHECKPOINT; 1999-06-11 CHECKPOINT is a Postgres language extension. There is no CHECKPOINT command in SQL92. The handling of database storage and logging is a matter that the standard leaves to the implementation.