# greenplum--summarize **Repository Path**: null_334/greenplum--summarize ## Basic Information - **Project Name**: greenplum--summarize - **Description**: 主要介绍作者使用过的Greenplum技术,欢迎大家交流 - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 3 - **Forks**: 0 - **Created**: 2020-07-27 - **Last Updated**: 2023-11-15 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # 更多关于Greenplum资料请查看以下链接 CSDN中关于Greenplum的资料 https://blog.csdn.net/xfg0218/article/category/7898386 腾讯云中关于Greenplum的资料 https://cloud.tencent.com/developer/column/72497 # 历史greenplum知识点介绍 ## 202006月 1、[修改Greenplum默认的CST时区](https://github.com/xfg0218/greenplum--summarize/tree/master/202006/greenplum%E6%97%B6%E5%8C%BA%E9%81%BF%E5%9D%91) 2、[greenplum元数据管理](https://github.com/xfg0218/greenplum--summarize/tree/master/202006/greenplum%E5%85%83%E6%95%B0%E6%8D%AE%E7%AE%A1%E7%90%86) 3、[greenplum6.x安装PXF插件](https://github.com/xfg0218/greenplum--summarize/tree/master/202006/greenplum6.x%E5%AE%89%E8%A3%85PXF%E6%8F%92%E4%BB%B6) 4、[greenplum6.x安装oracle_fdw插件](https://github.com/xfg0218/greenplum--summarize/tree/master/202006/greenplum6.x%E5%AE%89%E8%A3%85oracle_fdw) 5、[greenplum6.x安装mysql_fdw插件](https://github.com/xfg0218/greenplum--summarize/tree/master/202006) ## 202005月 1、[PostgreSQL中的多版本并发控制-MVCC](https://github.com/xfg0218/greenplum--summarize/tree/master/202005/mvcc%E8%AF%A6%E8%A7%A3) 2、[postgresql常用索引](https://github.com/xfg0218/greenplum--summarize/tree/master/202005/postgresql%E7%B4%A2%E5%BC%95) 3、[postgresql中数据库事务详解ACID](https://github.com/xfg0218/greenplum--summarize/tree/master/202005/postgresql%E4%B8%AD%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BA%8B%E5%8A%A1%E8%AF%A6%E8%A7%A3ACID) ## 202004月 1、[Greenplum数据库权限管理](https://github.com/xfg0218/greenplum--summarize/tree/master/202004/Greenplum%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9D%83%E9%99%90%E7%AE%A1%E7%90%86) 2、[Greenplum数据库巡检报告](https://github.com/xfg0218/greenplum--summarize/tree/master/202004/Greenplum%E6%95%B0%E6%8D%AE%E5%BA%93%E5%B7%A1%E6%A3%80%E6%8A%A5%E5%91%8A) ## 202003月 1、[Greenplum集群安装配置及最佳实践](https://github.com/xfg0218/greenplum--summarize/tree/master/202003/Greenplum%E9%9B%86%E7%BE%A4%E5%AE%89%E8%A3%85%E9%85%8D%E7%BD%AE%E5%8F%8A%E6%9C%80%E4%BD%B3%E5%AE%9E%E8%B7%B5) 2、[Greenplum应用开发](https://github.com/xfg0218/greenplum--summarize/tree/master/202003/Greenplum%E5%BA%94%E7%94%A8%E5%BC%80%E5%8F%91) 3、[Greenplum数据库调优](https://github.com/xfg0218/greenplum--summarize/tree/master/202003/Greenplum%E6%95%B0%E6%8D%AE%E5%BA%93%E8%B0%83%E4%BC%98) 4、[Greenplum架构和核心引擎](https://github.com/xfg0218/greenplum--summarize/tree/master/202003/Greenplum%E6%9E%B6%E6%9E%84%E5%92%8C%E6%A0%B8%E5%BF%83%E5%BC%95%E6%93%8E) 5、[Greenplum管理实战](https://github.com/xfg0218/greenplum--summarize/tree/master/202003/Greenplum%E7%AE%A1%E7%90%86%E5%AE%9E%E6%88%98) 6、[Greenplum内核揭秘之执行引擎](https://github.com/xfg0218/greenplum--summarize/blob/master/greenplum%E5%AD%A6%E4%B9%A0pdf%E6%96%87%E6%A1%A3/Greenplum%E4%BB%8E%E5%85%A5%E9%97%A8%E5%88%B0%E7%B2%BE%E9%80%9A/Greenplum%E5%86%85%E6%A0%B8%E6%8F%AD%E7%A7%98%E4%B9%8B%E6%89%A7%E8%A1%8C%E5%BC%95%E6%93%8E.pdf) ## 202002月 1、[Greenplum架构和核心引擎](https://github.com/xfg0218/greenplum--summarize/tree/master/202002/Greenplum%E6%9E%B6%E6%9E%84%E5%92%8C%E6%A0%B8%E5%BF%83%E5%BC%95%E6%93%8E) 2、[postgreSQL窗口函数总结](https://github.com/xfg0218/greenplum--summarize/tree/master/202002/Greenplum%E7%AA%97%E5%8F%A3%E5%87%BD%E6%95%B0%E6%80%BB%E7%BB%93) ## 202001月 1、[greenplum元数据常用查询语句](https://github.com/xfg0218/greenplum--summarize/tree/master/202001/greenplum%E5%85%83%E6%95%B0%E6%8D%AE%E4%BF%A1%E6%81%AF) 2、[greenplum查看表字段的注释信息](https://github.com/xfg0218/greenplum--summarize/tree/master/202001/%E6%9F%A5%E7%9C%8B%E8%A1%A8%E5%AD%97%E6%AE%B5%E7%9A%84%E6%B3%A8%E9%87%8A%E4%BF%A1%E6%81%AF) ## 201912月 1、[Greenplum 查看最新创建的表及大小](https://github.com/xfg0218/greenplum--summarize/tree/master/201912/%E6%9F%A5%E7%9C%8B%E6%9C%80%E6%96%B0%E7%9A%84%E8%A1%A8%E5%8F%8A%E5%A4%A7%E5%B0%8F) 2、[《Greenplum数据库使用总结(5.11版本).pdf》开源](https://github.com/xfg0218/greenplum--summarize/tree/master/greenplum%E5%AD%A6%E4%B9%A0pdf%E6%96%87%E6%A1%A3) ## 201911月 1、[《PostgreSQL指南内部探究》一书总结](https://github.com/xfg0218/greenplum--summarize/tree/master/201911/PostgresQL%E6%8C%87%E5%8D%97) 2、[Greenplum删除集群中赋权的用户](https://github.com/xfg0218/greenplum--summarize/tree/master/201911/user-drop) 3、[gptransfer命令同集群与异集群同步数据](https://github.com/xfg0218/greenplum--summarize/tree/master/201911/gptransfer) 4、[Ora2pg把oracle数据导入到postgres](https://github.com/xfg0218/greenplum--summarize/tree/master/201911/ora2pg) 5、[greenplum 对连接池pgbouncer的使用](https://github.com/xfg0218/greenplum--summarize/tree/master/201911/pgbouncer) ## 201910月 1、[《Greenplum 从大数据战略到实现》的总结](https://github.com/xfg0218/greenplum--summarize/blob/master/201910/greenplum%E4%BB%8E%E5%A4%A7%E6%95%B0%E6%8D%AE%E6%88%98%E7%95%A5%E5%88%B0%E5%AE%9E%E7%8E%B0/README.md) 2、[greenplum链接kafka导入与导出数据](https://github.com/xfg0218/greenplum--summarize/tree/master/201910/greenplum-kafka) ## 201909月 1、[gpcrondump与gpdbrestore](https://github.com/xfg0218/greenplum--summarize/blob/master/201909/gpcrondump%E4%B8%8Egpdbrestore/README.md) 2、[greenplum常用的gp_toolkit监控语句](https://github.com/xfg0218/greenplum--summarize/tree/master/201909/gp_toolkit) 3、[greenplum常用的pg_catalog监控语句](https://github.com/xfg0218/greenplum--summarize/tree/master/201909/pg_catalog) ## 201908月 1、[OracleClobToGreenplum 把Oracle的clob字段同步到Greenplum的java工具](https://github.com/xfg0218/greenplum--summarize/tree/master/201908/OracleClobToGreenplum) 2、[Greenplum生产环境信息同步到test环境中](https://github.com/xfg0218/greenplum--summarize/tree/master/201908/pro-to-test) ## 201906 月 1、[查看greenplum集群中表的倾斜率](https://github.com/xfg0218/greenplum--summarize/tree/master/201906/greenplum-table-percentage) 2、[安装greenplum时对sysctl参数详解](https://github.com/xfg0218/greenplum--summarize/tree/master/201906/file-configure) 3、[使用streamsets工具把oracle数据导入到greenplum](https://github.com/xfg0218/greenplum--summarize/tree/master/201906/oracle-streamsets-greenplum) 4、[streamsets使用中常见错误PDF文档请查看 ](https://github.com/xfg0218/greenplum--summarize/blob/master/document/streamsets%E6%95%B0%E6%8D%AE%E9%87%87%E9%9B%86%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98%E6%B1%87%E6%80%BB.pdf) ## 201905 月 1、[清理greenplum中的AO表的空间](https://github.com/xfg0218/greenplum--summarize/tree/master/201905/greenplum-inspect-ao) 2、[gpcheckperf 测试集群详细信息](https://github.com/xfg0218/greenplum--summarize/blob/master/201905/gpcheckperf/README.md) # greenplum--summarize 项目介绍 项目主要介绍作者在项目上使用过的相关greenplum的相关的技术，欢迎大家相互交流,请关注以下的作者公众号或留言 ![image](https://github.com/xfg0218/greenplum--summarize/blob/master/images/wechat-images/wechat-images.png) ![images](https://github.com/xfg0218/greenplum--summarize/blob/master/images/wechat-images/watch-xiaoxu.png)