ADD PARTITION
You can add partitions to an existing partitioned table to maintain new services. Currently, a partitioned table can contain a maximum of 1048575 partitions. If the number of partitions reaches the upper limit, no more partitions can be added. In addition, the memory usage of partitions must be considered. Typically, the memory usage of a partitioned table is about (Number of partitions x 3/1024) MB. The memory usage of a partition cannot be greater than the value of local_syscache_threshold. In addition, some space must be reserved for other functions.
![](https://support.huaweicloud.com/intl/en-us/fg-gaussdb-cent/public_sys-resources/caution_3.0-en-us.png)
- This command cannot be applied to hash partitions.
- Adding a Partition to a Range Partitioned Table
- Adding a Partition to an Interval Partitioned Table
- Adding a Partition to a List Partitioned Table
- Adding a Partition to a Level-2 Partitioned Table
- Adding a Level-2 Partition to a Level-2 Partitioned Table
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot