diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-04-29 11:31:24 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-04-29 11:31:24 -0400 |
| commit | 94b9cb722552c37da78c8320bac1d5b55e34def6 (patch) | |
| tree | afe64ff23c789b32ba47a35c81e2855e96edf387 /doc/src | |
| parent | d9a9f4b4b92ad39e3c4e6600dc61d5603ddd6e24 (diff) | |
| download | postgresql-94b9cb722552c37da78c8320bac1d5b55e34def6.tar.gz postgresql-94b9cb722552c37da78c8320bac1d5b55e34def6.zip | |
Improve documentation for default_tablespace on partitioned tables
Backpatch to 12, where 87259588d0ab introduced the current behavior.
Per note from Justin Pryzby.
Co-authored-by: Justin Pryzby <pryzby@telsasoft.com>
Discussion: https://postgr.es/m/20210416143135.GI3315@telsasoft.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index cf75d913ce9..5efbfe97b5d 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -8268,8 +8268,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; <para> This variable specifies the default tablespace in which to create objects (tables and indexes) when a <command>CREATE</command> command does - not explicitly specify a tablespace. It also determines the tablespace - that a partitioned relation will direct future partitions to. + not explicitly specify a tablespace. </para> <para> @@ -8294,6 +8293,14 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; </para> <para> + If this parameter is set to a value other than the empty string + when a partitioned table is created, the partitioned table's + tablespace will be set to that value, which will be used as + the default tablespace for partitions created in the future, + even if <varname>default_tablespace</varname> has changed since then. + </para> + + <para> For more information on tablespaces, see <xref linkend="manage-ag-tablespaces"/>. </para> |