checkpoint - 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  checkpoint_segments and checkpoint_timeout.) The CHECKPOINT command forces
       an immediate checkpoint 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         2009-03-12                      CHECKPOINT()

Generated by $Id: phpMan.php,v 4.54 2007/08/21 09:05:22 chedong Exp $ Author: Che Dong
On Apache/2.2.3 (Red Hat)
Under GNU General Public License
2009-12-24 04:32 @127.0.0.1 CrawledBy CCBot/1.0 (+http://www.commoncrawl.org/bot.html)