diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-08-08 16:03:14 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-08-08 16:03:16 -0400 |
| commit | bf6455d4c557ff9ef42985bb4806b251497bdc60 (patch) | |
| tree | 0a47ca625c3af99ad50350a050627e4bd8ed0080 | |
| parent | 273e78715a0f92708f6b7b0c99393666e3281f72 (diff) | |
Clarify the default partition's role
Reviewed by Tom Lane and Amit Langote
Discussion: https://postgr.es/m/20190806222735.GA9535@alvherre.pgsql
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 12 |
1 files changed, 5 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index a2c7adecf1d..7cadd1a6aed 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -397,8 +397,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM Creates the table as a <firstterm>partition</firstterm> of the specified parent table. The table can be created either as a partition for specific values using <literal>FOR VALUES</literal> or as a default partition - using <literal>DEFAULT</literal>. This option is not available for - hash-partitioned tables. + using <literal>DEFAULT</literal>. </para> <para> @@ -488,16 +487,15 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> If <literal>DEFAULT</literal> is specified, the table will be - created as a default partition of the parent table. The parent can - either be a list or range partitioned table. A partition key value + created as the default partition of the parent table. This option + is not available for hash-partitioned tables. A partition key value not fitting into any other partition of the given parent will be - routed to the default partition. There can be only one default - partition for a given parent table. + routed to the default partition. </para> <para> When a table has an existing <literal>DEFAULT</literal> partition and - a new partition is added to it, the existing default partition must + a new partition is added to it, the default partition must be scanned to verify that it does not contain any rows which properly belong in the new partition. If the default partition contains a large number of rows, this may be slow. The scan will be skipped if |