Unix/Linux Go Back    

RedHat 9 (Linux i386) - man page for checkpoint (redhat section 7)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)

CHECKPOINT(7)				   SQL Commands 			    CHECKPOINT(7)

       CHECKPOINT - force a transaction log checkpoint


       Write-Ahead  Logging  (WAL)  puts  a checkpoint in the transaction log every so often. (To
       adjust the automatic checkpoint interval, see the run-time  configuration  options  CHECK-
       POINT_SEGMENTS and CHECKPOINT_TIMEOUT.)	The CHECKPOINT command forces an immediate check-
       point when the command is issued, without waiting for a scheduled checkpoint.

       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

       PostgreSQL Administrator's Guide

       The CHECKPOINT command is a PostgreSQL language extension.

SQL - Language Statements		    2002-11-22				    CHECKPOINT(7)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums

All times are GMT -4. The time now is 06:46 PM.