Question about Partition Table Documentation Description

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 分区表文档描述疑问

| username: 逍遥_猫

The official documentation here says “delete all partitions less than the given expression.” I guess this means “merge all partitions less than the given expression into the new first partition”?
Deleting partitions gives the impression that the data in the partitions is also deleted~
It makes more sense that the data in the partitions less than the given expression still exists.

2
| username: dba-kit | Original post link

Version 6.5 still does not support the REORGANIZE PARTITION operation. I suspect it will indeed directly drop the smaller partitions.

3
| username: 逍遥_猫 | Original post link

What about the data in the small partitions?

4
| username: dba-kit | Original post link

Since it has been dropped, the data is definitely lost. However, generally speaking, the First Partition is not usually modified, right?

5
| username: Jellybean | Original post link

This means that data will be deleted because you have set a new minimum partition. Therefore, the data in the partitions smaller than the new one will be deleted and cleaned up, which is in line with the original design.

The original intention of the official partition table design was to facilitate the deletion of large amounts of data. If you want to merge a large amount of data into a new partition, it would be inconsistent with the original design and usage on one hand; on the other hand, merging partition data means reorganizing the data, which consumes a lot of resources. Although after merging, you only need to query one partition, you can achieve the same purpose by expanding the query range without merging. In short, the benefits of merging are minimal and completely unnecessary.

6
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.