官方文档
http://docs.greenplum.org/6-4/ref_guide/sql_commands/VACUUM.html
greenplum数据删除后不会释放存储空间,需要命令VACUUM清理释放
命令格式
VACUUM [({ FULL | FREEZE | VERBOSE | ANALYZE } [, ...])] [table [(column [, ...] )]]
VACUUM [FULL] [FREEZE] [VERBOSE] [table]
VACUUM [FULL] [FREEZE] [VERBOSE] ANALYZE
[table [(column [, ...] )]]
VACUUM
清理删除的数据
VACUUM FULL
清理删除的数据并释放存储空间
ANALYZE
为查询分析器更新统计数据
全库执行(特别慢,建议分表执行)
VACUUM;
VACUUM ANALYZE;
分表执行
VACUUM ANALYZE table1;