Greenplum释放AO表SHELL脚本
Greenplum支持行储存(HEAP储存)与列(append-only)储存,对于AO存储，虽然是appendonly，但实际上GP是支持DELETE和UPDATE的，被删除或更新的行，通过BITMAP来标记删除与修改。AO存储是块级组织，当一个块内的数据大部分都被删除或更新掉时，扫描它浪费的成本实际上是很高的。而PostgreSQL是通过HOT技术以及autovacuum来避免或减少垃圾的。但是Greenplum没有自动回收的worker进程，所以需要人为的触发。接下来就分析AO表与HEAP表的问题以及如何解答，执行空间的释放有3中方法分别是:
1、执行VACUUM。（当膨胀率大于gp_appendonly_compaction_threshold参数时），为共享锁。
2、执行VACUUM FULL。（不管gp_appendonly_compaction_threshold参数的设置，都会回收垃圾空间。），为DDL锁，需要慎用这个命令，会把CPU与IO沾满。
3、执行重分布。（不管gp_appendonly_compaction_threshold参数，都会回收垃圾空间。），为DDL锁
文件下载
资源详情
[{"title":"（ 49 个子文件 31KB ） Greenplum释放AO表SHELL脚本","children":[{"title":"greenplum-inspect-ao","children":[{"title":"log","children":[{"title":"20181017","children":[{"title":"table-percent-hidden","children":[{"title":"ods.odsp_e_zj_ten_info_person_id.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo_tmp4credit_code.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.odsp_e_zj_ten_info_entid.txt <span style='color:#111;'> 13.42KB </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo_tmp4del.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.t_alter_event_tmp.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"main.dwd_en_baseinfo_regno.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo_tmp4insert.txt <span style='color:#111;'> 4.69KB </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo_col.txt <span style='color:#111;'> 13.42KB </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_gqcz_zx_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.t_ent_baseinfo_etl_tmp4processor.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.t_ent_baseinfo_etl.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.odsp_e_zj_ten_info.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_yc_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_gqcz_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_jyzx_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_xzcf_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"main.dwd_en_baseinfo_entname.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.odsp_e_zj_ten_info_merge.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo.txt <span style='color:#111;'> 13.42KB </span>","children":null,"spread":false},{"title":"ods.t_ent_baseinfo_etl_model4spider.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.odss_e_zj_yzwf_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_xzcf_xq_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_gqcz_bg_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_dcdy_dyw_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_dcdy_bg_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo_tmp4regno.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo_tmp4init_internal.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_dcdy_dj_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_qxxx_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_dcdy_dyr_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"main.dwd_en_baseinfo_credit_code.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_dcdy_bdbzq_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"main.t_ent_baseinfo_tmp4entname.txt <span style='color:#111;'> 9.01KB </span>","children":null,"spread":false},{"title":"main.dwd_alter_record.txt <span style='color:#111;'> 4.79KB </span>","children":null,"spread":false},{"title":"ods.t_alter_record_tmp.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_dcdy_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.t_ent_baseinfo_etl_tmp4entid.txt <span style='color:#111;'> 13.42KB </span>","children":null,"spread":false},{"title":"ods.odsp_e_zj_ten_info_issue.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_fzjg_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.t_ent_baseinfo_duplicate.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_dcdy_zx_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"ods.odss_c_zj_ccjc_20180728.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false}],"spread":false},{"title":"temp-inspect-results","children":[{"title":"20181017-main.txt <span style='color:#111;'> 422B </span>","children":null,"spread":false},{"title":"20181017-tra.txt <span style='color:#111;'> 1.52KB </span>","children":null,"spread":false},{"title":"20181017-finish.txt <span style='color:#111;'> 1.20KB </span>","children":null,"spread":false},{"title":"20181017-ods.txt <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"greenplum-inspect-ao.sh <span style='color:#111;'> 3.12KB </span>","children":null,"spread":false},{"title":"inspect-ao-sql","children":[{"title":"inspect-ao-ori.sql <span style='color:#111;'> 153B </span>","children":null,"spread":false},{"title":"inspect-ao-percent-hidden-ori.sql <span style='color:#111;'> 80B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]
评论信息
其他资源
- NIST随机数测试标准中文版
- OPNET-TDMA仿真.zip
- 股票预测（LSTM）
- 恶魔射手unity的项目和视频教程
- M73 UEFI黑苹果文件
- 用JAVA开发的在线问卷调查系统（WAR+源码+SQL）
- Oracle19c(19.3)数据库驱动ojdbc.jar
- Pytorch GPU显存充足却显示out of memory的解决方式
- Gaussian09 + Caussian View +海量资源
- PCB封装之-HDR-各种单双排针（1.27mm、2.0mm、2.54mm，史上最全）
- slf4j相关jar
- TM4C123自带LCD.rar
- dace工具包
- 2021年节假日.sql
- 网易云函数接口搭建.zip
- 《信号与系统》课件_郑君里第三版.7z
- EXE反编译工具VB版
- 《细说PHP(第2版)》
- 山东大学2018计科软件工程课程复习资料
- 模拟银行业务系统C++实现
- AI圣经pdf高清
- 最新尚硅谷Dubbo教程 视频课件完整不加密
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明