diff options
Diffstat (limited to 'doc/src/sgml/ref/checkpoint.sgml')
-rw-r--r-- | doc/src/sgml/ref/checkpoint.sgml | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/checkpoint.sgml b/doc/src/sgml/ref/checkpoint.sgml new file mode 100644 index 0000000..28a1d71 --- /dev/null +++ b/doc/src/sgml/ref/checkpoint.sgml @@ -0,0 +1,69 @@ +<!-- +doc/src/sgml/ref/checkpoint.sgml +PostgreSQL documentation +--> + +<refentry id="sql-checkpoint"> + <indexterm zone="sql-checkpoint"> + <primary>CHECKPOINT</primary> + </indexterm> + + <refmeta> + <refentrytitle>CHECKPOINT</refentrytitle> + <manvolnum>7</manvolnum> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>CHECKPOINT</refname> + <refpurpose>force a write-ahead log checkpoint</refpurpose> + </refnamediv> + + <refsynopsisdiv> +<synopsis> +CHECKPOINT +</synopsis> + </refsynopsisdiv> + + <refsect1> + <title>Description</title> + + <para> + A checkpoint is a point in the write-ahead 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 + <xref linkend="wal-configuration"/> for more details about what happens + during a checkpoint. + </para> + + <para> + The <command>CHECKPOINT</command> command forces an immediate + checkpoint when the command is issued, without waiting for a + regular checkpoint scheduled by the system (controlled by the settings in + <xref linkend="runtime-config-wal-checkpoints"/>). + <command>CHECKPOINT</command> is not intended for use during normal + operation. + </para> + + <para> + If executed during recovery, the <command>CHECKPOINT</command> command + will force a restartpoint (see <xref linkend="wal-configuration"/>) + rather than writing a new checkpoint. + </para> + + <para> + Only superusers or users with the privileges of + the <link linkend="predefined-roles-table"><literal>pg_checkpoint</literal></link> + role can call <command>CHECKPOINT</command>. + </para> + </refsect1> + + <refsect1> + <title>Compatibility</title> + + <para> + The <command>CHECKPOINT</command> command is a + <productname>PostgreSQL</productname> language extension. + </para> + </refsect1> +</refentry> |