From b4b8efbd3826ac0af2d1c2e7c40fcf80a4bfba45 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:18:03 +0200 Subject: Adding upstream version 15.6. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/ddl-partitioning.html | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'doc/src/sgml/html/ddl-partitioning.html') diff --git a/doc/src/sgml/html/ddl-partitioning.html b/doc/src/sgml/html/ddl-partitioning.html index d818fe4..7b3d0fd 100644 --- a/doc/src/sgml/html/ddl-partitioning.html +++ b/doc/src/sgml/html/ddl-partitioning.html @@ -1,5 +1,5 @@ -5.11. Table Partitioning
5.11. Table Partitioning
Prev UpChapter 5. Data DefinitionHome Next

5.11. Table Partitioning

5.11.1. Overview
5.11.2. Declarative Partitioning
5.11.3. Partitioning Using Inheritance
5.11.4. Partition Pruning
5.11.5. Partitioning and Constraint Exclusion
5.11.6. Best Practices for Declarative Partitioning

+5.11. Table Partitioning

5.11. Table Partitioning
Prev UpChapter 5. Data DefinitionHome Next

5.11. Table Partitioning

5.11.1. Overview
5.11.2. Declarative Partitioning
5.11.3. Partitioning Using Inheritance
5.11.4. Partition Pruning
5.11.5. Partitioning and Constraint Exclusion
5.11.6. Best Practices for Declarative Partitioning

PostgreSQL supports basic table partitioning. This section describes why and how to implement partitioning as part of your database design. @@ -368,7 +368,7 @@ ALTER TABLE measurement ATTACH PARTITION measurement_y2008m02 

 CREATE INDEX measurement_usls_idx ON ONLY measurement (unitsales);
 
-CREATE INDEX measurement_usls_200602_idx
+CREATE INDEX CONCURRENTLY measurement_usls_200602_idx
     ON measurement_y2006m02 (unitsales);
 ALTER INDEX measurement_usls_idx
     ATTACH PARTITION measurement_usls_200602_idx;
@@ -449,7 +449,9 @@ ALTER INDEX measurement_city_id_logdate_key
         Using ONLY to add or drop a constraint on only
         the partitioned table is supported as long as there are no
         partitions.  Once partitions exist, using ONLY
-        will result in an error.  Instead, constraints on the partitions
+        will result in an error for any constraints other than
+        UNIQUE and PRIMARY KEY.
+        Instead, constraints on the partitions
         themselves can be added and (if they are not present in the parent
         table) dropped.
        
  • 
@@ -989,4 +991,4 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01';
     painfully slow.  Simulations of the intended workload are often beneficial
     for optimizing the partitioning strategy.  Never just assume that more
     partitions are better than fewer partitions, nor vice-versa.
-
    • Prev Up Next
    5.10. Inheritance Home 5.12. Foreign Data
    \ No newline at end of file +

    Prev Up Next
    5.10. Inheritance Home 5.12. Foreign Data
    \ No newline at end of file -- cgit v1.2.3