SHRINK

Shrink ::= SHRINK TABLE table_name [nowait];

Shrink ::= SHRINK INDEX index_name [nowait];

--创建表row_compression
MogDB=# CREATE TABLE row_compression
(
    id int
) with (compresstype=2, compress_chunk_size = 512, compress_level = 1);

--插入数据
MogDB=# Insert into row_compression select generate_series(1,1000);

--查看数据
MogDB=# SELECT * FROM row_compression;

--shrink整理
MogDB=# SHRINK TABLE row_compression;

--删除表
MogDB=# DROP TABLE row_compression;