Content-Length: 321672 | pFad | http://github.com/postgrespro/postgres/commit/3fa0c78632210592d566daaeece25f3743c58233

64 Rearrange documentation paragraph describing pg_relation_size(). · postgrespro/postgres@3fa0c78 · GitHub
Skip to content

Commit 3fa0c78

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 c76a98e commit 3fa0c78

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
@@ -14494,18 +14494,34 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup());
1449414494
</para>
1449514495

1449614496
<para>
14497-
<function>pg_relation_size</> accepts the OID or name of a table, index or
14498-
toast table, and returns the on-disk size in bytes. Specifying
14499-
<literal>'main'</literal> or leaving out the second argument returns the
14500-
size of the main data fork of the relation. Specifying
14501-
<literal>'fsm'</literal> returns the size of the
14502-
Free Space Map (see <xref linkend="storage-fsm">) associated with the
14503-
relation. Specifying <literal>'vm'</literal> returns the size of the
14504-
Visibility Map (see <xref linkend="storage-vm">) associated with the
14505-
relation. Note that this function shows the size of only one fork;
14506-
for most purposes it is more convenient to use the higher-level
14507-
functions <function>pg_total_relation_size</> or
14508-
<function>pg_table_size</>.
14497+
<function>pg_relation_size</> accepts the OID or name of a table, index
14498+
or toast table, and returns the on-disk size in bytes of one fork of
14499+
that relation. (Note that for most purposes it is more convenient to
14500+
use the higher-level functions <function>pg_total_relation_size</>
14501+
or <function>pg_table_size</>, which sum the sizes of all forks.)
14502+
With one argument, it returns the size of the main data fork of the
14503+
relation. The second argument can be provided to specify which fork
14504+
to examine:
14505+
<itemizedlist spacing="compact">
14506+
<listitem>
14507+
<para>
14508+
<literal>'main'</literal> returns the size of the main
14509+
data fork of the relation.
14510+
</para>
14511+
</listitem>
14512+
<listitem>
14513+
<para>
14514+
<literal>'fsm'</literal> returns the size of the Free Space Map
14515+
(see <xref linkend="storage-fsm">) associated with the relation.
14516+
</para>
14517+
</listitem>
14518+
<listitem>
14519+
<para>
14520+
<literal>'vm'</literal> returns the size of the Visibility Map
14521+
(see <xref linkend="storage-vm">) associated with the relation.
14522+
</para>
14523+
</listitem>
14524+
</itemizedlist>
1450914525
</para>
1451014526

1451114527
<para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/3fa0c78632210592d566daaeece25f3743c58233

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy