ADD PARTITION

You can add partitions to an existing partitioned table to maintain new services. Currently, a partitioned table supports a maximum of 1,048,575 partitions. Once the upper limit is reached, no more partitions can be added.

The memory overhead occupied by partitions needs to be considered in this process. The memory used by a partitioned table is about (Number of partitions x 3/1024) MB. The memory occupied by partitions cannot be greater than the value of local_syscache_threshold. In addition, a certain amount of memory space needs to be reserved to ensure that other functions can run properly.

• This command cannot be applied to hash partitions.
• New partitions do not inherit the sparsely partitioned index attribute of the table.

• Adding a Partition to a Range Partitioned Table
  
• Adding a Partition to a List Partitioned Table