Using MOT Overview

MOT is automatically deployed as part of openGauss. You may refer to the MOT Preparation section for a description of how to estimate and plan required memory and storage resources in order to sustain your workload. The MOT Deployment section describes all the configuration settings in MOT, as well as non-mandatory options for server optimization.

Using MOT tables is quite simple. The syntax of all MOT commands is the same as for disk-based tables and includes support for most of standard PostgreSQL SQL, DDL and DML commands and features, such as Stored Procedures. Only the create and drop table statements in MOT differ from the statements for disk-based tables in openGauss. You may refer to the MOT Usage section for a description of these two simple commands, to learn how to convert a disk-based table into an MOT table, to get higher performance using Query Native Compilation and PREPARE statements and for a description of external tool support and the limitations of the MOT engine.

The MOT Administration section describes how to perform database maintenance, monitoring and analysis of logs and reported errors. Lastly, the MOT Sample TPC-C Benchmark section describes how to perform a standard TPC-C benchmark.

• Read the following topics to learn how to use MOT -