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

Commit4fd9e6f

Browse files
committed
Rearrange documentation paragraph describing pg_relation_size().
Break the list of available options into an <itemizedlist> instead ofinline sentences. This is mostly motivated by wanting to ensure that thecross-references to the FSM and VM docs don't cross page boundaries in PDFformat; but it seems to me to read more easily this way anyway. I took theliberty of editorializing a bit further while at it.Per complaint from Magnus about 9.0.18 docs not building in A4 format.Patch all active branches so we don't get blind-sided by this particularissue again in future.
1 parent0ea1f2a commit4fd9e6f

File tree

1 file changed

+34
-14
lines changed

1 file changed

+34
-14
lines changed

‎doc/src/sgml/func.sgml‎

Lines changed: 34 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -16928,20 +16928,40 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup());
1692816928
</para>
1692916929

1693016930
<para>
16931-
<function>pg_relation_size</> accepts the OID or name of a table, index or
16932-
toast table, and returns the on-disk size in bytes.
16933-
Specifying <literal>'main'</literal> or leaving out the second argument
16934-
returns the size of the main data fork of the relation.
16935-
Specifying <literal>'fsm'</literal> returns the size of the Free Space
16936-
Map (see <xref linkend="storage-fsm">) associated with the relation.
16937-
Specifying <literal>'vm'</literal> returns the size of the Visibility
16938-
Map (see <xref linkend="storage-vm">) associated with the relation.
16939-
Specifying <literal>'init'</literal> returns the size of the
16940-
initialization fork, if any, associated with the relation.
16941-
Note that this function shows the size of only one fork;
16942-
for most purposes it is more convenient to use the higher-level
16943-
functions <function>pg_total_relation_size</> or
16944-
<function>pg_table_size</>.
16931+
<function>pg_relation_size</> accepts the OID or name of a table, index
16932+
or toast table, and returns the on-disk size in bytes of one fork of
16933+
that relation. (Note that for most purposes it is more convenient to
16934+
use the higher-level functions <function>pg_total_relation_size</>
16935+
or <function>pg_table_size</>, which sum the sizes of all forks.)
16936+
With one argument, it returns the size of the main data fork of the
16937+
relation. The second argument can be provided to specify which fork
16938+
to examine:
16939+
<itemizedlist spacing="compact">
16940+
<listitem>
16941+
<para>
16942+
<literal>'main'</literal> returns the size of the main
16943+
data fork of the relation.
16944+
</para>
16945+
</listitem>
16946+
<listitem>
16947+
<para>
16948+
<literal>'fsm'</literal> returns the size of the Free Space Map
16949+
(see <xref linkend="storage-fsm">) associated with the relation.
16950+
</para>
16951+
</listitem>
16952+
<listitem>
16953+
<para>
16954+
<literal>'vm'</literal> returns the size of the Visibility Map
16955+
(see <xref linkend="storage-vm">) associated with the relation.
16956+
</para>
16957+
</listitem>
16958+
<listitem>
16959+
<para>
16960+
<literal>'init'</literal> returns the size of the initialization
16961+
fork, if any, associated with the relation.
16962+
</para>
16963+
</listitem>
16964+
</itemizedlist>
1694516965
</para>
1694616966

1694716967
<para>

0 commit comments

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