diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 47 | ||||
| -rw-r--r-- | doc/src/sgml/ref/analyze.sgml | 7 | ||||
| -rw-r--r-- | doc/src/sgml/ref/vacuum.sgml | 4 |
3 files changed, 31 insertions, 27 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index ef0f7cf7270..09b5b3ff70d 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -3792,8 +3792,7 @@ UNION ALL SELECT * FROM measurement_y2008m01; <title>Caveats</title> <para> - The following caveats apply to partitioned tables implemented using either - method (unless noted otherwise): + The following caveats apply to using inheritance to implement partitioning: <itemizedlist> <listitem> <para> @@ -3803,13 +3802,6 @@ UNION ALL SELECT * FROM measurement_y2008m01; partitions and creates and/or modifies associated objects than to write each by hand. </para> - - <para> - This is not a problem with partitioned tables though, as trying to - create a partition that overlaps with one of the existing partitions - results in an error, so it is impossible to end up with partitions - that overlap one another. - </para> </listitem> <listitem> @@ -3822,14 +3814,6 @@ UNION ALL SELECT * FROM measurement_y2008m01; on the partition tables, but it makes management of the structure much more complicated. </para> - - <para> - This problem exists even for partitioned tables. An <command>UPDATE</> - that causes a row to move from one partition to another fails, because - the new value of the row fails to satisfy the implicit partition - constraint of the original partition. This might change in future - releases. - </para> </listitem> <listitem> @@ -3840,8 +3824,7 @@ UNION ALL SELECT * FROM measurement_y2008m01; <programlisting> ANALYZE measurement; </programlisting> - will only process the master table. This is true even for partitioned - tables. + will only process the master table. </para> </listitem> @@ -3852,11 +3835,27 @@ ANALYZE measurement; action is only taken in case of unique violations on the specified target relation, not its child relations. </para> + </listitem> + </itemizedlist> + </para> + <para> + The following caveats apply to partitioned tables created with the + explicit syntax: + <itemizedlist> + <listitem> + <para> + An <command>UPDATE</> that causes a row to move from one partition to + another fails, because the new value of the row fails to satisfy the + implicit partition constraint of the original partition. This might + change in future releases. + </para> + </listitem> + + <listitem> <para> <command>INSERT</command> statements with <literal>ON CONFLICT</> - clause are currently not allowed on partitioned tables, that is, - cause error when specified. + clause are currently not allowed on partitioned tables. </para> </listitem> @@ -3864,7 +3863,8 @@ ANALYZE measurement; </para> <para> - The following caveats apply to constraint exclusion: + The following caveats apply to constraint exclusion, which is currently + used by both inheritance and partitioned tables: <itemizedlist> <listitem> @@ -3898,8 +3898,7 @@ ANALYZE measurement; during constraint exclusion, so large numbers of partitions are likely to increase query planning time considerably. Partitioning using these techniques will work well with up to perhaps a hundred partitions; - don't try to use many thousands of partitions. This restriction applies - both to inheritance and explicit partitioning syntax. + don't try to use many thousands of partitions. </para> </listitem> diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml index 27ab4fca42c..49727e22dff 100644 --- a/doc/src/sgml/ref/analyze.sgml +++ b/doc/src/sgml/ref/analyze.sgml @@ -63,8 +63,11 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table_name</replaceable> [ <listitem> <para> The name (possibly schema-qualified) of a specific table to - analyze. If omitted, all regular tables (but not foreign tables) - in the current database are analyzed. + analyze. If omitted, all regular tables, partitioned tables, and + and materialized views in the current database are analyzed (but not + foreign tables). If the specified table is a partitioned table, both the + inheritance statistics of the partitioned table as a whole and + statistics of the individual partitions are updated. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index f18180a2fa2..543ebcf6493 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -153,7 +153,9 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ <replaceable class="PARAMETER"> <listitem> <para> The name (optionally schema-qualified) of a specific table to - vacuum. Defaults to all tables in the current database. + vacuum. If omitted, all regular tables and materialized views in the + current database are vacuumed. If the specified table is a partitioned + table, all of its leaf partitions are vacuumed. </para> </listitem> </varlistentry> |
