postgres.git / summary / log / commit / refs

commit    1da2f64fd166a1ad7c26dc04c82d538be5ac986f
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Wed Jul 23 19:20:40 2014 +0000
First released in: 9.5.0, 9.0.19, 9.1.15, 9.2.10, 9.3.6, 9.4.0

    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.


doc/src/sgml/func.sgml | 40 ++++++++++++++++++++++++++++------------ 1 file changed, 28 insertions(+), 12 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 3630ba6fc06..76bd58d306d 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15098,18 +15098,34 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup()); </para> <para> - <function>pg_relation_size</> accepts the OID or name of a table, index or - toast table, and returns the on-disk size in bytes. Specifying - <literal>'main'</literal> or leaving out the second argument returns the - size of the main data fork of the relation. Specifying - <literal>'fsm'</literal> returns the size of the - Free Space Map (see <xref linkend="storage-fsm">) associated with the - relation. Specifying <literal>'vm'</literal> returns the size of the - Visibility Map (see <xref linkend="storage-vm">) associated with the - relation. Note that this function shows the size of only one fork; - for most purposes it is more convenient to use the higher-level - functions <function>pg_total_relation_size</> or - <function>pg_table_size</>. + <function>pg_relation_size</> accepts the OID or name of a table, index + or toast table, and returns the on-disk size in bytes of one fork of + that relation. (Note that for most purposes it is more convenient to + use the higher-level functions <function>pg_total_relation_size</> + or <function>pg_table_size</>, which sum the sizes of all forks.) + With one argument, it returns the size of the main data fork of the + relation. The second argument can be provided to specify which fork + to examine: + <itemizedlist spacing="compact"> + <listitem> + <para> + <literal>'main'</literal> returns the size of the main + data fork of the relation. + </para> + </listitem> + <listitem> + <para> + <literal>'fsm'</literal> returns the size of the Free Space Map + (see <xref linkend="storage-fsm">) associated with the relation. + </para> + </listitem> + <listitem> + <para> + <literal>'vm'</literal> returns the size of the Visibility Map + (see <xref linkend="storage-vm">) associated with the relation. + </para> + </listitem> + </itemizedlist> </para> <para> [parent: 748da01d392f]