Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   6284 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

CHECKPOINT()			 SQL Commands			  CHECKPOINT()

NAME
       CHECKPOINT - Force 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_TIME‐
       OUT.)  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 the PostgreSQL Administra‐
       tor's Guide for more information about the WAL system.

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

SEE ALSO
       PostgreSQL Administrator's Guide

COMPATIBILITY
       The CHECKPOINT command is a PostgreSQL language extension.

SQL - Language Statements	  2001-01-24			  CHECKPOINT()

                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 

Vote for polarhome