'Does openGauss MOT storage engine support table partition?
The MOT storage engine has excellent perfomance in one datanode. But my application data has reached PB level, thus can't be held in one machine, is there any method to solve it?
Solution 1:[1]
For now, openGauss does not support table partition. Partitioning of very large tables can be done by the application or stored-procedure logic.
Cheers
PS. details on MOT functionality, usage, limitations and benchmarks can be found here: https://opengauss.org/en/docs/2.1.0/docs/Developerguide/using-mot.html
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Vladi V |