Skip site navigation (1)Skip section navigation (2)

  
 
  

home | help
CHECKPOINT(7)		  PostgreSQL 18.6 Documentation 	   CHECKPOINT(7)

NAME
     CHECKPOINT - force a write-ahead log checkpoint

SYNOPSIS
     CHECKPOINT

DESCRIPTION
     A	checkpoint  is a point in the write-ahead 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 Section 28.5 for more details about
     what happens during a checkpoint.

     The  CHECKPOINT  command forces an immediate checkpoint when the command is
     issued, without waiting for a regular checkpoint scheduled  by  the  system
     (controlled by the settings in Section 19.5.2).  CHECKPOINT is not intended
     for use during normal operation.

     If  executed  during recovery, the CHECKPOINT command will force a restart-
     point (see Section 28.5) rather than writing a new checkpoint.

     Only superusers or users with the privileges of the pg_checkpoint role  can
     call CHECKPOINT.

COMPATIBILITY
     The CHECKPOINT command is a PostgreSQL language extension.

PostgreSQL 18.6 		      2026			   CHECKPOINT(7)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=CHECKPOINT&sektion=7&manpath=FreeBSD+Ports+15.1.quarterly>

home | help