Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitbf6455d

Browse files
committed
Clarify the default partition's role
Reviewed by Tom Lane and Amit LangoteDiscussion:https://postgr.es/m/20190806222735.GA9535@alvherre.pgsql
1 parent273e787 commitbf6455d

File tree

1 file changed

+5
-7
lines changed

1 file changed

+5
-7
lines changed

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 5 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -397,8 +397,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
397397
Creates the table as a <firstterm>partition</firstterm> of the specified
398398
parent table. The table can be created either as a partition for specific
399399
values using <literal>FOR VALUES</literal> or as a default partition
400-
using <literal>DEFAULT</literal>. This option is not available for
401-
hash-partitioned tables.
400+
using <literal>DEFAULT</literal>.
402401
</para>
403402

404403
<para>
@@ -488,16 +487,15 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
488487

489488
<para>
490489
If <literal>DEFAULT</literal> is specified, the table will be
491-
created asa default partition of the parent table.The parent can
492-
either be a list or rangepartitionedtable. A partition key value
490+
created asthe default partition of the parent table. This option
491+
is not available for hash-partitionedtables. A partition key value
493492
not fitting into any other partition of the given parent will be
494-
routed to the default partition. There can be only one default
495-
partition for a given parent table.
493+
routed to the default partition.
496494
</para>
497495

498496
<para>
499497
When a table has an existing <literal>DEFAULT</literal> partition and
500-
a new partition is added to it, theexistingdefault partition must
498+
a new partition is added to it, the default partition must
501499
be scanned to verify that it does not contain any rows which properly
502500
belong in the new partition. If the default partition contains a
503501
large number of rows, this may be slow. The scan will be skipped if

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp