diff options
author | Robert Haas <rhaas@postgresql.org> | 2021-03-22 10:34:10 -0400 |
---|---|---|
committer | Robert Haas <rhaas@postgresql.org> | 2021-03-22 10:34:10 -0400 |
commit | 24f0e395ac5892cd12e8914646fe921fac5ba23d (patch) | |
tree | 1da61b7c3c5b2468fe730412860a737380be54bd /doc/src | |
parent | 226e2be3876d0bda3dc33d16dfa0bed246b7b74f (diff) | |
download | postgresql-24f0e395ac5892cd12e8914646fe921fac5ba23d.tar.gz postgresql-24f0e395ac5892cd12e8914646fe921fac5ba23d.zip |
docs: Fix omissions related to configurable TOAST compression.
Previously, the default_toast_compression GUC was not documented,
and neither was pg_dump's new --no-toast-compression option.
Justin Pryzby and Robert Haas
Discussion: http://postgr.es/m/20210321235544.GD4203@telsasoft.com
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/config.sgml | 22 | ||||
-rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 12 |
2 files changed, 34 insertions, 0 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index ee4925d6d92..5679b40dd56 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -8108,6 +8108,28 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; </listitem> </varlistentry> + <varlistentry id="guc-default-toast-compression" xreflabel="default_toast_compression"> + <term><varname>default_toast_compression</varname> (<type>string</type>) + <indexterm> + <primary><varname>default_toast_compression</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + This variable sets the default + <link linkend="storage-toast">TOAST</link> + compression method for columns of newly-created tables. The + <command>CREATE TABLE</command> statement can override this default + by specifying the <literal>COMPRESSION</literal> column option. + + The supported compression methods are <literal>pglz</literal> and + (if configured at the time <productname>PostgreSQL</productname> was + built) <literal>lz4</literal>. + The default is <literal>pglz</literal>. + </para> + </listitem> + </varlistentry> + <varlistentry id="guc-default-tablespace" xreflabel="default_tablespace"> <term><varname>default_tablespace</varname> (<type>string</type>) <indexterm> diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index bcbb7a25fb7..989b8e23815 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -932,6 +932,18 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--no-toast-compression</option></term> + <listitem> + <para> + Do not output commands to set <acronym>TOAST</acronym> compression + methods. + With this option, all objects will be created using whichever + compression method is the default during restore. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--no-unlogged-table-data</option></term> <listitem> <para> |