From 956451e8bc9face2241d9a785e0d236a92f8e210 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Thu, 8 Aug 2019 16:03:14 -0400 Subject: [PATCH] Clarify the default partition's role Reviewed by Tom Lane and Amit Langote Discussion: https://postgr.es/m/20190806222735.GA9535@alvherre.pgsql --- doc/src/sgml/ref/create_table.sgml | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 9009addb9c..c922954c64 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -399,8 +399,7 @@ WITH ( MODULUS numeric_literal, REM Creates the table as a partition of the specified parent table. The table can be created either as a partition for specific values using FOR VALUES or as a default partition - using DEFAULT. This option is not available for - hash-partitioned tables. + using DEFAULT. @@ -491,16 +490,15 @@ WITH ( MODULUS numeric_literal, REM If DEFAULT 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. When a table has an existing DEFAULT 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 -- 2.40.0