Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitec03f41

Browse files
Document LSN acronym in WAL Internals
We previously didn't mention what an LSN actually was.Simon Riggs and Michael Paquier
1 parentd851bef commitec03f41

File tree

2 files changed

+26
-0
lines changed

2 files changed

+26
-0
lines changed

‎doc/src/sgml/acronyms.sgml

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -380,6 +380,16 @@
380380
</listitem>
381381
</varlistentry>
382382

383+
<varlistentry>
384+
<term><acronym>LSN</acronym></term>
385+
<listitem>
386+
<para>
387+
Log Sequence Number, see <link linkend="datatype-pg-lsn"><type>pg_lsn</></link>
388+
and <link linkend="wal-internals">WAL Internals</link>.
389+
</para>
390+
</listitem>
391+
</varlistentry>
392+
383393
<varlistentry>
384394
<term><acronym>MSVC</acronym></term>
385395
<listitem>

‎doc/src/sgml/wal.sgml

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -724,6 +724,10 @@
724724
<sect1 id="wal-internals">
725725
<title>WAL Internals</title>
726726

727+
<indexterm zone="wal-internals">
728+
<primary>LSN</primary>
729+
</indexterm>
730+
727731
<para>
728732
<acronym>WAL</acronym> is automatically enabled; no action is
729733
required from the administrator except ensuring that the
@@ -732,6 +736,18 @@
732736
linkend="wal-configuration">).
733737
</para>
734738

739+
<para>
740+
<acronym>WAL</acronym> records are appended to the <acronym>WAL</acronym>
741+
logs as each new record is written. The insert position is described by
742+
a Log Sequence Number (<acronym>LSN</acronym>) that is a byte offset into
743+
the logs, increasing monotonically with each new record.
744+
<acronym>LSN</acronym> values are returned as the datatype
745+
<link linkend="datatype-pg-lsn"><type>pg_lsn</></link>. Values can be
746+
compared to calculate the volume of <acronym>WAL</acronym> data that
747+
separates them, so they are used to measure the progress of replication
748+
and recovery.
749+
</para>
750+
735751
<para>
736752
<acronym>WAL</acronym> logs are stored in the directory
737753
<filename>pg_xlog</filename> under the data directory, as a set of

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp