CHECKPOINT

An SQL command which forces a transaction log checkpoint

CHECKPOINT is an SQL command which forces PostgreSQL to carry out an immediate checkpoint, after which the on-disk datafiles are guaranteed to be up-to-date as of the point the command was executed.

CHECKPOINT can only be executed by a superuser. It is unlikely that this command will be required during normal database operation.

Categories

Management / adminstration, SQL command

See also

checkpoint