http://200yi.com/ff_internal/ 2026-04-27T20:32:41+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2026-03-19T09:05:08+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Apache%20Cloudberry%EF%BC%9A%E8%84%B1%E9%A2%96%E8%80%8C%E5%87%BA%E7%9A%84GPDB%E7%BB%A7%E4%BB%BB%E8%80%85&rev=1773882308&do=diff 一、概况 Greenplum Database于2024年5月，在没有任何公告的情况下存档闭源。对于存量用户和开发者，纷纷寻找替代方案。从目前情况看主要有三大项目可担当继任者，那么谁又更胜一筹，能够脱颖而出呢？ text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Greenplum%E5%B8%B8%E7%94%A8%E5%91%BD%E4%BB%A4&rev=1687008318&do=diff 一、数据分布 查看表的分布键方式 tpch1000s=# select c.relname, policytype, numsegments, distkey from pg_class c, pg_catalog.gp_distribution_policy gpp where c.oid = gpp.localoid; relname | policytype | numsegments | distkey ----------+------------+-------------+--------- nation | p | 192 | 1 region | p | 192 | 1 part | p | 192 | 1 $$ {标准差\ } \sigma = \sum_{i=1}^N\sqrt{\frac{(x_i-\overline{x})^2}{n}} $$$$ {变异系数\ } C_V = \frac{\sigma}{\overlin… text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Greenplum%E9%9B%86%E7%BE%A4%E4%BD%BF%E7%94%A8%E5%9F%BA%E7%A1%80&rev=1687008318&do=diff 查看、启动、停止集群状态 * 集群状态：gpstate * 启动集群：gpstart * 停止集群：gpstop 集群状态 gpstate -e #查看mirror的状态 gpstate -f #查看standby master的状态 gpstate -s #查看整个GP群集的状态 gpstate -i #查看GP的版本 gpstate --help #帮助文档，可以查看gpstate更多用法 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Greenplum%E5%BC%80%E5%8D%B7%E6%9C%89%E7%9B%8A&rev=1687008318&do=diff 1. 基础 * Greenplum数据库® 6.0文档 * 聊聊Greenplum的那些事 * 海量数据处理利器greenplum——初识 * greenplum数据库引擎探究 2. GPDB (Greenplum Database) * greenplum中的内存分配方法 * Greenplum资源队列初识 * Greenplum数据库权限管理 * Greenplum ：基于 PostgreSQL 的分布式数据库内核揭秘 (上篇) * Greenplum ：基于 PostgreSQL 的分布式数据库内核揭秘 (下篇) * Greenplum常用的gp_toolkit & pg_catalog监控语句 * HashData产品文档 * Greenplum扩展数据节点及表数据重分布 * Greenplum Segment 的检测机制 * Greenplum 分布式数据库内核揭秘(上篇) * Greenplum 分布式数据库内核揭秘(下篇) 3. GPCC (Greenplum Command Center) * GPCC官方安装文档 * GP安… text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Greenplum%E9%97%AE%E9%A2%98%E6%9D%82%E8%AE%B0&rev=1687008318&do=diff 一、单机模式问题 1. “select * from pg_resqueue_status; ” crash crash重现方法： [gpadmin@bogon ~]$ gpstart -a -m [gpadmin@bogon ~]$ PGOPTIONS='-c gp_session_role=utility' psqlp's -d postgres psql (9.4.24) Type "help" for help. postgres=# select * from pg_resqueue_status; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. _______$$ statement\_mem < = 资源队列的… text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Greenplum%E7%B3%BB%E7%BB%9F%E8%A1%A8%E5%91%BD%E4%BB%A4&rev=1687008318&do=diff 查看表、索引等创建日志 test=# select * from pg_stat_last_operation; classid | objid | staactionname | stasysid | stausename | stasubtype | statime ---------+-------+---------------+----------+----------------+------------+------------------------------- 1259 | 24677 | CREATE | 10 | gpadmin | TABLE | 2019-09-08 11:14:29.446554+08 1259 | 24684 | CREATE | 10 | gpadmin | TABLE | 2019-09-08 11:14:29.467163+08 1259 | 5007 | VACUUM … text/html 2024-05-30T01:00:05+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Greenplum%E6%BA%90%E7%A0%81%E4%B8%AD%E7%9A%84%E6%9C%AF%E8%AF%AD&rev=1717002005&do=diff gdd Global DeadLock Detector AMS Active Memory Sharing, is a virtualization technology that allows multiple partitions to share a pool of physical memory. This is designed to increase system memory utilization, thereby enabling you to realize a cost benefit by reducing the amount of physical memory required. text/html 2023-07-14T01:00:04+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:GreenPlum:Pivotal%20Greenplum%20Documentation&rev=1689267604&do=diff 点击下载阅读：[下载] * Pivotal Greenplum® 6.9 Documentation * Greenplum 6 中文文档