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

Commit15afb7d

Browse files
committed
doc: Fix section of functions age(xid) and mxid_age(xid)
In 17~, age(xid) and mxid_age(xid) were listed as deprecated. Based onthe discussion that led to48b5aa3, this is not intentional as thiscould break many existing monitoring queries. Note that vacuumdb alsouses both of them.In 16, both functions were listed under "Control Data Functions", whichis incorrect, so let's move them to the list of functions related totransaction IDs and snapshots.Author: Bertrand DrouvotDiscussion:https://postgr.es/m/Zzr2zZFyeFKXWe8a@ip-10-97-1-34.eu-west-3.compute.internalDiscussion:https://postgr.es/m/20231114013224.4z6oxa6p6va33rxr@awork3.anarazel.deBackpatch-through: 16
1 parenta43d7a8 commit15afb7d

File tree

1 file changed

+30
-28
lines changed

1 file changed

+30
-28
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 30 additions & 28 deletions
Original file line numberDiff line numberDiff line change
@@ -27138,6 +27138,34 @@ acl | {postgres=arwdDxtm/postgres,foo=r/postgres}
2713827138
</thead>
2713927139

2714027140
<tbody>
27141+
<row>
27142+
<entry role="func_table_entry"><para role="func_signature">
27143+
<indexterm>
27144+
<primary>age</primary>
27145+
</indexterm>
27146+
<function>age</function> ( <type>xid</type> )
27147+
<returnvalue>integer</returnvalue>
27148+
</para>
27149+
<para>
27150+
Returns the number of transactions between the supplied
27151+
transaction id and the current transaction counter.
27152+
</para></entry>
27153+
</row>
27154+
27155+
<row>
27156+
<entry role="func_table_entry"><para role="func_signature">
27157+
<indexterm>
27158+
<primary>mxid_age</primary>
27159+
</indexterm>
27160+
<function>mxid_age</function> ( <type>xid</type> )
27161+
<returnvalue>integer</returnvalue>
27162+
</para>
27163+
<para>
27164+
Returns the number of multixacts IDs between the supplied
27165+
multixact ID and the current multixacts counter.
27166+
</para></entry>
27167+
</row>
27168+
2714127169
<row>
2714227170
<entry role="func_table_entry"><para role="func_signature">
2714327171
<indexterm>
@@ -27282,7 +27310,8 @@ acl | {postgres=arwdDxtm/postgres,foo=r/postgres}
2728227310
<para>
2728327311
The internal transaction ID type <type>xid</type> is 32 bits wide and
2728427312
wraps around every 4 billion transactions. However,
27285-
the functions shown in <xref linkend="functions-pg-snapshot"/> use a
27313+
the functions shown in <xref linkend="functions-pg-snapshot"/>, except
27314+
<function>age</function> and <function>mxid_age</function>, use a
2728627315
64-bit type <type>xid8</type> that does not wrap around during the life
2728727316
of an installation and can be converted to <type>xid</type> by casting if
2728827317
required; see <xref linkend="transaction-id"/> for details.
@@ -27364,33 +27393,6 @@ acl | {postgres=arwdDxtm/postgres,foo=r/postgres}
2736427393
</thead>
2736527394

2736627395
<tbody>
27367-
<row>
27368-
<entry role="func_table_entry"><para role="func_signature">
27369-
<indexterm>
27370-
<primary>age</primary>
27371-
</indexterm>
27372-
<function>age</function> ( <type>xid</type> )
27373-
<returnvalue>integer</returnvalue>
27374-
</para>
27375-
<para>
27376-
Returns the number of transactions between the supplied
27377-
transaction id and the current transaction counter.
27378-
</para></entry>
27379-
</row>
27380-
27381-
<row>
27382-
<entry role="func_table_entry"><para role="func_signature">
27383-
<indexterm>
27384-
<primary>mxid_age</primary>
27385-
</indexterm>
27386-
<function>mxid_age</function> ( <type>xid</type> )
27387-
<returnvalue>integer</returnvalue>
27388-
</para>
27389-
<para>
27390-
Returns the number of multixacts IDs between the supplied
27391-
multixact ID and the current multixacts counter.
27392-
</para></entry>
27393-
</row>
2739427396

2739527397
<row>
2739627398
<entry role="func_table_entry"><para role="func_signature">

0 commit comments

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