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

Commitedc793d

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 parent4116420 commitedc793d

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
@@ -399,8 +399,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
399399
Creates the table as a <firstterm>partition</firstterm> of the specified
400400
parent table. The table can be created either as a partition for specific
401401
values using <literal>FOR VALUES</literal> or as a default partition
402-
using <literal>DEFAULT</literal>. This option is not available for
403-
hash-partitioned tables.
402+
using <literal>DEFAULT</literal>.
404403
</para>
405404

406405
<para>
@@ -491,16 +490,15 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
491490

492491
<para>
493492
If <literal>DEFAULT</literal> is specified, the table will be
494-
created asa default partition of the parent table.The parent can
495-
either be a list or rangepartitionedtable. A partition key value
493+
created asthe default partition of the parent table. This option
494+
is not available for hash-partitionedtables. A partition key value
496495
not fitting into any other partition of the given parent will be
497-
routed to the default partition. There can be only one default
498-
partition for a given parent table.
496+
routed to the default partition.
499497
</para>
500498

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

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp