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

Commitb27f863

Browse files
committed
docs: Reframe track_io_timing related docs as wait time
With AIO it does not make sense anymore to track the time for each individualIO, as multiple IOs can be in-flight at the same time. Instead we now trackthe time spent *waiting* for IOs.This should be reflected in the docs. While, so far, we only do a subset ofreads, and no other operations, via AIO, describing the GUC and view columnsas measuring IO waits is accurate for synchronous and asynchronous IO.Reviewed-by: Noah Misch <noah@leadboat.com>Discussion:https://postgr.es/m/5dzyoduxlvfg55oqtjyjehez5uoq6hnwgzor4kkybkfdgkj7ag@rbi4gsmzaczk
1 parent12ce89f commitb27f863

File tree

2 files changed

+8
-8
lines changed

2 files changed

+8
-8
lines changed

‎doc/src/sgml/config.sgml‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8568,7 +8568,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
85688568
</term>
85698569
<listitem>
85708570
<para>
8571-
Enables timing of database I/Ocalls. This parameter is off by
8571+
Enables timing of database I/Owaits. This parameter is off by
85728572
default, as it will repeatedly query the operating system for
85738573
the current time, which may cause significant overhead on some
85748574
platforms. You can use the <xref linkend="pgtesttiming"/> tool to
@@ -8602,7 +8602,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
86028602
</term>
86038603
<listitem>
86048604
<para>
8605-
Enables timing of WAL I/Ocalls. This parameter is off by default,
8605+
Enables timing of WAL I/Owaits. This parameter is off by default,
86068606
as it will repeatedly query the operating system for the current time,
86078607
which may cause significant overhead on some platforms.
86088608
You can use the <application>pg_test_timing</application> tool to

‎doc/src/sgml/monitoring.sgml‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -2747,7 +2747,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
27472747
<structfield>read_time</structfield> <type>double precision</type>
27482748
</para>
27492749
<para>
2750-
Time spentin read operations in milliseconds (if
2750+
Time spentwaiting for read operations in milliseconds (if
27512751
<xref linkend="guc-track-io-timing"/> is enabled and
27522752
<varname>object</varname> is not <literal>wal</literal>,
27532753
or if <xref linkend="guc-track-wal-io-timing"/> is enabled
@@ -2785,7 +2785,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
27852785
<structfield>write_time</structfield> <type>double precision</type>
27862786
</para>
27872787
<para>
2788-
Time spentin write operations in milliseconds (if
2788+
Time spentwaiting for write operations in milliseconds (if
27892789
<xref linkend="guc-track-io-timing"/> is enabled and
27902790
<varname>object</varname> is not <literal>wal</literal>,
27912791
or if <xref linkend="guc-track-wal-io-timing"/> is enabled
@@ -2813,7 +2813,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
28132813
<structfield>writeback_time</structfield> <type>double precision</type>
28142814
</para>
28152815
<para>
2816-
Time spentin writeback operations in milliseconds (if
2816+
Time spentwaiting for writeback operations in milliseconds (if
28172817
<xref linkend="guc-track-io-timing"/> is enabled, otherwise zero). This
28182818
includes the time spent queueing write-out requests and, potentially,
28192819
the time spent to write out the dirty data.
@@ -2849,7 +2849,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
28492849
<structfield>extend_time</structfield> <type>double precision</type>
28502850
</para>
28512851
<para>
2852-
Time spentin extend operations in milliseconds. (if
2852+
Time spentwaiting for extend operations in milliseconds. (if
28532853
<xref linkend="guc-track-io-timing"/> is enabled and
28542854
<varname>object</varname> is not <literal>wal</literal>,
28552855
or if <xref linkend="guc-track-wal-io-timing"/> is enabled
@@ -2923,7 +2923,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
29232923
<structfield>fsync_time</structfield> <type>double precision</type>
29242924
</para>
29252925
<para>
2926-
Time spentin fsync operations in milliseconds (if
2926+
Time spentwaiting for fsync operations in milliseconds (if
29272927
<xref linkend="guc-track-io-timing"/> is enabled and
29282928
<varname>object</varname> is not <literal>wal</literal>,
29292929
or if <xref linkend="guc-track-wal-io-timing"/> is enabled
@@ -3010,7 +3010,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
30103010

30113011
<note>
30123012
<para>
3013-
Columns tracking I/O time will only be non-zero when
3013+
Columns tracking I/Owaittime will only be non-zero when
30143014
<xref linkend="guc-track-io-timing"/> is enabled. The user should be
30153015
careful when referencing these columns in combination with their
30163016
corresponding I/O operations in case <varname>track_io_timing</varname>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp