agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedMinor documentation fixes related to v18
3+ messages / 1 participants
[nested] [flat]
* Minor documentation fixes related to v18
@ 2025-06-19 10:34 Fujii Masao <masao.fujii@oss.nttdata.com>
2025-06-24 15:28 ` Re: Minor documentation fixes related to v18 Fujii Masao <masao.fujii@oss.nttdata.com>
0 siblings, 1 reply; 3+ messages in thread
From: Fujii Masao @ 2025-06-19 10:34 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
Hi,
I'd like to propose three minor documentation fixes related to parameters
introduced in v18. Since they align with new content in that version,
I'm thinking to apply them to v18. Thoughts?
0001:
For parameters that exist as both configuration and storage options,
the documentation usually includes secondary index entries to help users
find them easily. However, such entries were missing for vacuum_truncate
and vacuum_max_eager_freeze_failure_rate. This patch adds the appropriate
index terms.
0002:
The description of track_cost_delay_timing lists where cost-based vacuum
delay timing information is shown when the setting is enabled. Although
this information also appears in ANALYZE VERBOSE output, that wasn't
mentioned. This patch adds it to the list.
0003:
The io_workers parameter was documented with the type "int", but
the standard format in our docs is "integer". This patch updates it
for consistency with other GUC parameter descriptions.
Regards,
--
Fujii Masao
NTT DATA Japan Corporation
From eee26a3c056e5c9951cc9c304c8a5b6ce4c44d9c Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Thu, 19 Jun 2025 17:52:58 +0900
Subject: [PATCH v1 1/3] doc: Add secondary index entries for vacuum-related
parameters.
For parameters that exist as both configuration and storage options,
the documentation typically includes secondary index entries to
help users distinguish and locate the relevant references easily.
However, such index entries were missing for vacuum_truncate and
vacuum_max_eager_freeze_failure_rate, both introduced in v18.
This commit adds appropriate secondary index terms for these parameters
to ensure consistency with other parameters and improve usability of
the documentation index.
---
doc/src/sgml/config.sgml | 6 ++++--
doc/src/sgml/ref/create_table.sgml | 3 ++-
2 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index b265cc89c9d..0ac519706a4 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -9340,7 +9340,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<varlistentry id="guc-vacuum-truncate" xreflabel="vacuum_truncate">
<term><varname>vacuum_truncate</varname> (<type>boolean</type>)
<indexterm>
- <primary><varname>vacuum_truncate</varname> configuration parameter</primary>
+ <primary><varname>vacuum_truncate</varname></primary>
+ <secondary>configuration parameter</secondary>
</indexterm>
</term>
<listitem>
@@ -9544,7 +9545,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<varlistentry id="guc-vacuum-max-eager-freeze-failure-rate" xreflabel="vacuum_max_eager_freeze_failure_rate">
<term><varname>vacuum_max_eager_freeze_failure_rate</varname> (<type>floating point</type>)
<indexterm>
- <primary><varname>vacuum_max_eager_freeze_failure_rate</varname> configuration parameter</primary>
+ <primary><varname>vacuum_max_eager_freeze_failure_rate</varname></primary>
+ <secondary>configuration parameter</secondary>
</indexterm>
</term>
<listitem>
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 4a41b2f5530..ca1121318c2 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1687,7 +1687,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
<varlistentry id="reloption-vacuum-truncate" xreflabel="vacuum_truncate">
<term><literal>vacuum_truncate</literal>, <literal>toast.vacuum_truncate</literal> (<type>boolean</type>)
<indexterm>
- <primary><varname>vacuum_truncate</varname> storage parameter</primary>
+ <primary><varname>vacuum_truncate</varname></primary>
+ <secondary>storage parameter</secondary>
</indexterm>
</term>
<listitem>
--
2.49.0
From 2e793bae571c83334e2886574dbff0dc34e66a8a Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Thu, 19 Jun 2025 18:27:52 +0900
Subject: [PATCH v1 2/3] doc: Mention ANALYZE VERBOSE in
track_cost_delay_timing description.
The documentation for track_cost_delay_timing describes where cost-based
vacuum delay timing information is displayed when the setting is enabled.
While this information is also shown in the output of ANALYZE VERBOSE,
that was previously omitted from the list.
This commit updates the documentation to include ANALYZE VERBOSE in the list,
clarifying that it also reports cost-based delay timing information.
---
doc/src/sgml/config.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 0ac519706a4..f4ba58bb5c3 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -8602,7 +8602,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
timing information is displayed in
<link linkend="vacuum-progress-reporting"><structname>pg_stat_progress_vacuum</structname></link>,
<link linkend="analyze-progress-reporting"><structname>pg_stat_progress_analyze</structname></link>,
- in the output of <xref linkend="sql-vacuum"/> when the
+ in the output of <xref linkend="sql-vacuum"/> and
+ <xref linkend="sql-analyze"/> when the
<literal>VERBOSE</literal> option is used, and by autovacuum for
auto-vacuums and auto-analyzes when
<xref linkend="guc-log-autovacuum-min-duration"/> is set.
--
2.49.0
From 08243545f466ad12170d4abadd44dad9d7105d80 Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Thu, 19 Jun 2025 19:08:08 +0900
Subject: [PATCH v1 3/3] doc: Fix type description of io_workers GUC for
consistency.
The documentation previously described the type of the io_workers GUC
parameter as "int". However, the documentation consistently uses "integer"
for parameters of this type.
This commit updates the type description of io_workers to "integer"
for consistency with other GUC parameter descriptions.
---
doc/src/sgml/config.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index f4ba58bb5c3..59a0874528a 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -2788,7 +2788,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-io-workers" xreflabel="io_workers">
- <term><varname>io_workers</varname> (<type>int</type>)
+ <term><varname>io_workers</varname> (<type>integer</type>)
<indexterm>
<primary><varname>io_workers</varname> configuration parameter</primary>
</indexterm>
--
2.49.0
Attachments:
[text/plain] v1-0001-doc-Add-secondary-index-entries-for-vacuum-relate.patch (2.9K, ../../e95c899a-2aeb-45b7-8fd3-7a27dcdb475b@oss.nttdata.com/2-v1-0001-doc-Add-secondary-index-entries-for-vacuum-relate.patch)
download | inline diff:
From eee26a3c056e5c9951cc9c304c8a5b6ce4c44d9c Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Thu, 19 Jun 2025 17:52:58 +0900
Subject: [PATCH v1 1/3] doc: Add secondary index entries for vacuum-related
parameters.
For parameters that exist as both configuration and storage options,
the documentation typically includes secondary index entries to
help users distinguish and locate the relevant references easily.
However, such index entries were missing for vacuum_truncate and
vacuum_max_eager_freeze_failure_rate, both introduced in v18.
This commit adds appropriate secondary index terms for these parameters
to ensure consistency with other parameters and improve usability of
the documentation index.
---
doc/src/sgml/config.sgml | 6 ++++--
doc/src/sgml/ref/create_table.sgml | 3 ++-
2 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index b265cc89c9d..0ac519706a4 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -9340,7 +9340,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<varlistentry id="guc-vacuum-truncate" xreflabel="vacuum_truncate">
<term><varname>vacuum_truncate</varname> (<type>boolean</type>)
<indexterm>
- <primary><varname>vacuum_truncate</varname> configuration parameter</primary>
+ <primary><varname>vacuum_truncate</varname></primary>
+ <secondary>configuration parameter</secondary>
</indexterm>
</term>
<listitem>
@@ -9544,7 +9545,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<varlistentry id="guc-vacuum-max-eager-freeze-failure-rate" xreflabel="vacuum_max_eager_freeze_failure_rate">
<term><varname>vacuum_max_eager_freeze_failure_rate</varname> (<type>floating point</type>)
<indexterm>
- <primary><varname>vacuum_max_eager_freeze_failure_rate</varname> configuration parameter</primary>
+ <primary><varname>vacuum_max_eager_freeze_failure_rate</varname></primary>
+ <secondary>configuration parameter</secondary>
</indexterm>
</term>
<listitem>
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 4a41b2f5530..ca1121318c2 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1687,7 +1687,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
<varlistentry id="reloption-vacuum-truncate" xreflabel="vacuum_truncate">
<term><literal>vacuum_truncate</literal>, <literal>toast.vacuum_truncate</literal> (<type>boolean</type>)
<indexterm>
- <primary><varname>vacuum_truncate</varname> storage parameter</primary>
+ <primary><varname>vacuum_truncate</varname></primary>
+ <secondary>storage parameter</secondary>
</indexterm>
</term>
<listitem>
--
2.49.0
[text/plain] v1-0002-doc-Mention-ANALYZE-VERBOSE-in-track_cost_delay_t.patch (1.6K, ../../e95c899a-2aeb-45b7-8fd3-7a27dcdb475b@oss.nttdata.com/3-v1-0002-doc-Mention-ANALYZE-VERBOSE-in-track_cost_delay_t.patch)
download | inline diff:
From 2e793bae571c83334e2886574dbff0dc34e66a8a Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Thu, 19 Jun 2025 18:27:52 +0900
Subject: [PATCH v1 2/3] doc: Mention ANALYZE VERBOSE in
track_cost_delay_timing description.
The documentation for track_cost_delay_timing describes where cost-based
vacuum delay timing information is displayed when the setting is enabled.
While this information is also shown in the output of ANALYZE VERBOSE,
that was previously omitted from the list.
This commit updates the documentation to include ANALYZE VERBOSE in the list,
clarifying that it also reports cost-based delay timing information.
---
doc/src/sgml/config.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 0ac519706a4..f4ba58bb5c3 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -8602,7 +8602,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
timing information is displayed in
<link linkend="vacuum-progress-reporting"><structname>pg_stat_progress_vacuum</structname></link>,
<link linkend="analyze-progress-reporting"><structname>pg_stat_progress_analyze</structname></link>,
- in the output of <xref linkend="sql-vacuum"/> when the
+ in the output of <xref linkend="sql-vacuum"/> and
+ <xref linkend="sql-analyze"/> when the
<literal>VERBOSE</literal> option is used, and by autovacuum for
auto-vacuums and auto-analyzes when
<xref linkend="guc-log-autovacuum-min-duration"/> is set.
--
2.49.0
[text/plain] v1-0003-doc-Fix-type-description-of-io_workers-GUC-for-co.patch (1.2K, ../../e95c899a-2aeb-45b7-8fd3-7a27dcdb475b@oss.nttdata.com/4-v1-0003-doc-Fix-type-description-of-io_workers-GUC-for-co.patch)
download | inline diff:
From 08243545f466ad12170d4abadd44dad9d7105d80 Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Thu, 19 Jun 2025 19:08:08 +0900
Subject: [PATCH v1 3/3] doc: Fix type description of io_workers GUC for
consistency.
The documentation previously described the type of the io_workers GUC
parameter as "int". However, the documentation consistently uses "integer"
for parameters of this type.
This commit updates the type description of io_workers to "integer"
for consistency with other GUC parameter descriptions.
---
doc/src/sgml/config.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index f4ba58bb5c3..59a0874528a 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -2788,7 +2788,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-io-workers" xreflabel="io_workers">
- <term><varname>io_workers</varname> (<type>int</type>)
+ <term><varname>io_workers</varname> (<type>integer</type>)
<indexterm>
<primary><varname>io_workers</varname> configuration parameter</primary>
</indexterm>
--
2.49.0
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Minor documentation fixes related to v18
2025-06-19 10:34 Minor documentation fixes related to v18 Fujii Masao <masao.fujii@oss.nttdata.com>
@ 2025-06-24 15:28 ` Fujii Masao <masao.fujii@oss.nttdata.com>
2025-06-25 00:06 ` Re: Minor documentation fixes related to v18 Fujii Masao <masao.fujii@oss.nttdata.com>
0 siblings, 1 reply; 3+ messages in thread
From: Fujii Masao @ 2025-06-24 15:28 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
On 2025/06/19 19:34, Fujii Masao wrote:
> Hi,
>
> I'd like to propose three minor documentation fixes related to parameters
> introduced in v18. Since they align with new content in that version,
> I'm thinking to apply them to v18. Thoughts?
>
> 0001:
> For parameters that exist as both configuration and storage options,
> the documentation usually includes secondary index entries to help users
> find them easily. However, such entries were missing for vacuum_truncate
> and vacuum_max_eager_freeze_failure_rate. This patch adds the appropriate
> index terms.
>
> 0002:
> The description of track_cost_delay_timing lists where cost-based vacuum
> delay timing information is shown when the setting is enabled. Although
> this information also appears in ANALYZE VERBOSE output, that wasn't
> mentioned. This patch adds it to the list.
>
> 0003:
> The io_workers parameter was documented with the type "int", but
> the standard format in our docs is "integer". This patch updates it
> for consistency with other GUC parameter descriptions.
These patches are straightforward fixes. Unless there are any objections,
I'll go ahead and commit them.
Regards,
--
Fujii Masao
NTT DATA Japan Corporation
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Minor documentation fixes related to v18
2025-06-19 10:34 Minor documentation fixes related to v18 Fujii Masao <masao.fujii@oss.nttdata.com>
2025-06-24 15:28 ` Re: Minor documentation fixes related to v18 Fujii Masao <masao.fujii@oss.nttdata.com>
@ 2025-06-25 00:06 ` Fujii Masao <masao.fujii@oss.nttdata.com>
0 siblings, 0 replies; 3+ messages in thread
From: Fujii Masao @ 2025-06-25 00:06 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
On 2025/06/25 0:28, Fujii Masao wrote:
>
>
> On 2025/06/19 19:34, Fujii Masao wrote:
>> Hi,
>>
>> I'd like to propose three minor documentation fixes related to parameters
>> introduced in v18. Since they align with new content in that version,
>> I'm thinking to apply them to v18. Thoughts?
>>
>> 0001:
>> For parameters that exist as both configuration and storage options,
>> the documentation usually includes secondary index entries to help users
>> find them easily. However, such entries were missing for vacuum_truncate
>> and vacuum_max_eager_freeze_failure_rate. This patch adds the appropriate
>> index terms.
>>
>> 0002:
>> The description of track_cost_delay_timing lists where cost-based vacuum
>> delay timing information is shown when the setting is enabled. Although
>> this information also appears in ANALYZE VERBOSE output, that wasn't
>> mentioned. This patch adds it to the list.
>>
>> 0003:
>> The io_workers parameter was documented with the type "int", but
>> the standard format in our docs is "integer". This patch updates it
>> for consistency with other GUC parameter descriptions.
>
> These patches are straightforward fixes. Unless there are any objections,
> I'll go ahead and commit them.
Pushed.
Regards,
--
Fujii Masao
NTT DATA Japan Corporation
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-06-25 00:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-06-19 10:34 Minor documentation fixes related to v18 Fujii Masao <masao.fujii@oss.nttdata.com>
2025-06-24 15:28 ` Fujii Masao <masao.fujii@oss.nttdata.com>
2025-06-25 00:06 ` Fujii Masao <masao.fujii@oss.nttdata.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox