8000 Document age(xid) and mxid_age(xid). · postgres/postgres@326f2aa · GitHub
[go: up one dir, main page]

Skip to content

Commit 326f2aa

Browse files
Document age(xid) and mxid_age(xid).
These functions have been around for some time, but commits 48b5aa3 and 15afb7d were only back-patched to v16. Let's back-patch them to all supported versions now. Reported-by: David Rowley <dgrowleyml@gmail.com> (commit 48b5aa3) Author: Bruce Momjian <bruce@momjian.us> (commit 48b5aa3) Co-authored-by: Bertrand Drouvot <bertranddrouvot.pg@gmail.com> (commit 15afb7d) Reviewed-by: Michael Paquier <michael@paquier.xyz> (commit 15afb7d) Reviewed-by: Robert Haas <robertmhaas@gmail.com> Reviewed-by: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://postgr.es/m/aGMCxHxLfeMdQk8m%40nathan Backpatch-through: 13-15
1 parent 25cab44 commit 326f2aa

File tree

1 file changed

+30
-1
lines changed

1 file changed

+30
-1
lines changed

doc/src/sgml/func.sgml

Lines changed: 30 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -24114,6 +24114,34 @@ SELECT collation for ('foo' COLLATE "de_DE");
2411424114
</thead>
2411524115

2411624116
<tbody>
24117+
<row>
24118+
<entry role="func_table_entry"><para role="func_signature">
24119+
<indexterm>
24120+
<primary>age</primary>
24121+
</indexterm>
24122+
<function>age</function> ( <type>xid</type> )
24123+
<returnvalue>integer</returnvalue>
24124+
</para>
24125+
<para>
24126+
Returns the number of transactions between the supplied
24127+
transaction id and the current transaction counter.
24128+
</para></entry>
24129+
</row>
24130+
24131+
<row>
24132+
<entry role="func_table_entry"><para role="func_signature">
24133+
<indexterm>
24134+
<primary>mxid_age</primary>
24135+
</indexterm>
24136+
<function>mxid_age</function> ( <type>xid</type> )
24137+
<returnvalue>integer</returnvalue>
24138+
</para>
24139+
<para>
24140+
Returns the number of multixacts IDs between the supplied
24141+
multixact ID and the current multixacts counter.
24142+
</para></entry>
24143+
</row>
24144+
2411724145
<row>
2411824146
<entry role="func_table_entry"><para role="func_signature">
2411924147
<indexterm>
@@ -24249,7 +24277,8 @@ SELECT collation for ('foo' COLLATE "de_DE");
2424924277
<para>
2425024278
The internal transaction ID type <type>xid</type> is 32 bits wide and
2425124279
wraps around every 4 billion transactions. However,
24252-
the functions shown in <xref linkend="functions-pg-snapshot"/> use a
24280+
the functions shown in <xref linkend="functions-pg-snapshot"/>, except
24281+
<function>age</function> and <function>mxid_age</function>, use a
2425324282
64-bit type <type>xid8</type> that does not wrap around during the life
2425424283
of an installation, and can be converted to <type>xid</type> by casting if
2425524284
required. The data type <type>pg_snapshot</type> stores information about

0 commit comments

Comments
 (0)
0