Creating/Dropping an MOT Table

Creating a Memory Optimized Table (MOT) is very simple. Only the create and drop table statements in MOT differ from the statements for disk-based tables in openGauss. The syntax of all other commands for SELECT, DML and DDL are the same for MOT tables as for openGauss disk-based tables.

· To create an MOT table –

· Always use the FOREIGN keyword to refer to MOT tables.

· The [server mot_server] part is optional when creating an MOT table because MOT is an integrated engine, not a separate server.

· The above is an extremely simple example creating a table named test with a single integer column named x. In the next section (Creating an Index) a more realistic example is provided.

· MOT tables cannot be created if incremental checkpoint is enabled in postgresql.conf. So please set enable_incremental_checkpoint to off before creating the MOT.

· To drop an MOT table named test –

· ALTER TABLE –

support includes Add column, Drop column and Rename column.

For a description of the limitations of supported features for MOT tables, such as data types, see the MOT SQL Coverage and Limitations section.