checkpoint man page on SuSE

Man page or keyword search:  
man Server   14857 pages
apropos Keyword Search (all sections)
Output format
SuSE logo
[printable version]

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_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 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	  2013-02-04			  CHECKPOINT()
[top]

List of man pages available for SuSE

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net