Skip to content

Commit c7ec796

Browse files
committed
Rearrange documentation paragraph describing pg_relation_size().
Break the list of available options into an <itemizedlist> instead of inline sentences. This is mostly motivated by wanting to ensure that the cross-references to the FSM and VM docs don't cross page boundaries in PDF format; but it seems to me to read more easily this way anyway. I took the liberty 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 particular issue again in future.
1 parent 9f519fa commit c7ec796

File tree

1 file changed

+28
-12
lines changed

1 file changed

+28
-12
lines changed

doc/src/sgml/func.sgml

Lines changed: 28 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -15703,18 +15703,34 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup());
1570315703
</para>
1570415704

1570515705
<para>
15706-
<function>pg_relation_size</> accepts the OID or name of a table, index or
15707-
toast table, and returns the on-disk size in bytes. Specifying
15708-
<literal>'main'</literal> or leaving out the second argument returns the
15709-
size of the main data fork of the relation. Specifying
15710-
<literal>'fsm'</literal> returns the size of the
15711-
Free Space Map (see <xref linkend="storage-fsm">) associated with the
15712-
relation. Specifying <literal>'vm'</literal> returns the size of the
15713-
Visibility Map (see <xref linkend="storage-vm">) associated with the
15714-
relation. Note that this function shows the size of only one fork;
15715-
for most purposes it is more convenient to use the higher-level
15716-
functions <function>pg_total_relation_size</> or
15717-
<function>pg_table_size</>.
15706+
<function>pg_relation_size</> accepts the OID or name of a table, index
15707+
or toast table, and returns the on-disk size in bytes of one fork of
15708+
that relation. (Note that for most purposes it is more convenient to
15709+
use the higher-level functions <function>pg_total_relation_size</>
15710+
or <function>pg_table_size</>, which sum the sizes of all forks.)
15711+
With one argument, it returns the size of the main data fork of the
15712+
relation. The second argument can be provided to specify which fork
15713+
to examine:
15714+
<itemizedlist spacing="compact">
15715+
<listitem>
15716+
<para>
15717+
<literal>'main'</literal> returns the size of the main
15718+
data fork of the relation.
15719+
</para>
15720+
</listitem>
15721+
<listitem>
15722+
<para>
15723+
<literal>'fsm'</literal> returns the size of the Free Space Map
15724+
(see <xref linkend="storage-fsm">) associated with the relation.
15725+
</para>
15726+
</listitem>
15727+
<listitem>
15728+
<para>
15729+
<literal>'vm'</literal> returns the size of the Visibility Map
15730+
(see <xref linkend="storage-vm">) associated with the relation.
15731+
</para>
15732+
</listitem>
15733+
</itemizedlist>
1571815734
</para>
1571915735

1572015736
<para>

0 commit comments

Comments
 (0)