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

Commit2f70871

Browse files
committed
doc: Recommend pg_stat_io rather than pg_stat_wal in WAL configuration
Sincea051e71, pg_stat_io is able to track statistics for the WALactivity, providing an equivalent of pg_stat_wal with more granularityfor the fsyncs/writes counts and timings, as the data is split acrossbackend types.This commit now recommends pg_stat_io rather than pg_stat_wal in thesection "WAL configuration", some of the latter's attributes beingcandidate for removal in a follow-up commit.Extracted from a larger patch by the same author.Author: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>Discussion:https://postgr.es/m/Z7RkQ0EfYaqqjgz/@ip-10-97-1-34.eu-west-3.compute.internal
1 parent71f1782 commit2f70871

File tree

1 file changed

+8
-6
lines changed

1 file changed

+8
-6
lines changed

‎doc/src/sgml/wal.sgml

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -810,11 +810,12 @@
810810
<para>
811811
There are two internal functions to write WAL data to disk:
812812
<function>XLogWrite</function> and <function>issue_xlog_fsync</function>.
813-
When <xref linkend="guc-track-wal-io-timing"/> is enabled, the total
813+
When <xref linkend="guc-track-io-timing"/> is enabled, the total
814814
amounts of time <function>XLogWrite</function> writes and
815815
<function>issue_xlog_fsync</function> syncs WAL data to disk are counted as
816-
<literal>wal_write_time</literal> and <literal>wal_sync_time</literal> in
817-
<xref linkend="pg-stat-wal-view"/>, respectively.
816+
<varname>write_time</varname> and <varname>sync_time</varname> in
817+
<xref linkend="pg-stat-io-view"/> for the <varname>object</varname>
818+
<literal>wal</literal>, respectively.
818819
<function>XLogWrite</function> is normally called by
819820
<function>XLogInsertRecord</function> (when there is no space for the new
820821
record in WAL buffers), <function>XLogFlush</function> and the WAL writer,
@@ -829,11 +830,12 @@
829830
<literal>fsync</literal>, or <literal>fsync_writethrough</literal>,
830831
the write operation moves WAL buffers to kernel cache and
831832
<function>issue_xlog_fsync</function> syncs them to disk. Regardless
832-
of the setting of <varname>track_wal_io_timing</varname>, the number
833+
of the setting of <varname>track_io_timing</varname>, the number
833834
of times <function>XLogWrite</function> writes and
834835
<function>issue_xlog_fsync</function> syncs WAL data to disk are also
835-
counted as <literal>wal_write</literal> and <literal>wal_sync</literal>
836-
in <structname>pg_stat_wal</structname>, respectively.
836+
counted as <varname>writes</varname> and <varname>fsyncs</varname>
837+
in <structname>pg_stat_io</structname> for the <varname>object</varname>
838+
<literal>wal</literal>, respectively.
837839
</para>
838840

839841
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp