checkpoint(7) - phpMan

CHECKPOINT()                               SQL Commands                              CHECKPOINT()



NAME
       CHECKPOINT - force a transaction log checkpoint


SYNOPSIS
       CHECKPOINT


DESCRIPTION
       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 in the documentation for more information about the WAL system.

       Only superusers can call CHECKPOINT. The command is not intended  for  use  during  normal
       operation.

COMPATIBILITY
       The CHECKPOINT command is a PostgreSQL language extension.



SQL - Language Statements                   2011-09-22                               CHECKPOINT()

Generated by $Id: phpMan.php,v 4.49 2006/02/26 13:18:18 chedong Exp $ Author: Che Dong
On Apache
Under GNU General Public License
2012-05-25 15:02 @38.107.179.238 Crawled by CCBot/1.0 (+http://www.commoncrawl.org/bot.html)