Greenplum 6.0 新特性介绍

最新推荐文章于 2022-07-03 02:06:14 发布
最新推荐文章于 2022-07-03 02:06:14 发布
阅读量165 收藏
点赞数
CC 4.0 BY-SA版权
文章标签： 数据库 分布式 大数据 java 编程语言
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/gp_community/article/details/109720586
Greenplum 6.0是基于PostgreSQL 9.4开发的分布式MPP数据库，新特性包括WAL日志同步、死锁检测、复制表、在线扩容、磁盘限额等功能，广泛应用于金融、电信、零售等领域。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

获得技术资料内容，请访问Greenplum中文社区网站

在1月12日举办的Greenplum开源有道智数未来技术研讨会上，Pivotal中国研发中心Greenplum 产品经理李阳向大家介绍了Greenplum 6.0 新特性。

Greenplum是Pivotal公司投入研发十多年，基于开源PostgreSQL数据库开发的一款Share-Nothing架构的分布式MPP数据库，具备高并发、高可用和高灵活等多种特性，可以对大任务、复杂任务进行快速高效计算，恰到好处地满足并行数据计算性能和海量数据管理的需求，目前在金融、电信、零售等领域有着广泛应用。

Greenplum 6在升级PostgreSQL内核至9.4版本的同时，增加了大量新特性，包括基于WAL日志的mirror同步、分布式死锁检测、复制表、在线扩容、磁盘限额、自动master切换、zStandard压缩、GP-GP集群间高效查询等，在此次演讲中分析介绍了这些新特性。

分享PPT

07ca22e5-c1b5-4b5a-a001-66e22c0e3789.jpg

最低0.47元/天 解锁文章

200万优质内容无限畅学
盘点Greenplum 6.0六大新特性及展望
大数据
01-21 2555
导读：本文介绍Greenplum 6.0的新特性。作者：王春波来源：大数据DT（ID：hzdashuju）Greenplum 6.0于2019年9月4日正式发布，内核版本从PostgreS...
Greenplum 6.0正式发布！8大特性重塑开源大数据生态
Greenplum中文社区
09-04 327
今天（2019年9月4日），Pivotal公司Greenplum产品总监Ivan Novick在北京举办的Gr...
greenplum6.1官方文档
11-25
greenplum6.1官方文档
分析：Greenplum发布6.0
weixin_34101784的博客
03-25 688
消息见：https://greenplum.cn/2019/03/20/greenplum6-0/?from=timeline&isappinstalled=0 Greenplum 6.0在社区陆陆续续也是做了很久，从2017年就开始规划功能，到如今落地历时两年。诸多新特性算是颇有吸引力，无论从运维方面、事务能力、功能丰富程度等方面都有提升。这里...
PPT | Greenplum 6 新功能
Greenplum中文社区
12-04 191
Pivotal预计将在明年发布Greenplum 6。新版的数据库不仅完成Postgresql多个内核版本的升级，而且开发了众多新功能。通过演讲Pivotal ...
全新的Greenplum 6.0内核优化解读和7.0展望.pdf
04-12
本文将从Greenplum 6.0内核新技术、新特性解读以及未来7.0版本的展望三个方面，详细解读Greenplum此次版本升级所带来的变化。 首先，从Greenplum 6.0内核新技术来看，Greenplum 6.0在内核升级上做出了巨大努力。它...
Greenplum 6.0 版本介绍
Greenplum中文社区
04-09 943
...
Greenplum 6.0 版本官方最强解读
Greenplum中文社区
10-22 733
...
Greenplum 6.0集群部署与管理工具安装包
根据提供的文件信息，我们...其6.0版本的发布带来了新特性和改进，并通过提供的安装包和监控管理工具支持在Linux环境下进行高效部署和管理。这些信息对于IT专业人士在部署和维护Greenplum集群时具有重要的参考价值。
转：Greenplum 6 新功能 在线扩容工具GPExpand
weixin_30432179的博客
09-26 354
https://www.cnblogs.com/zhangrui153169/p/11435581.html 转载于:https://www.cnblogs.com/datacat/p/11592611.html
greenplum-db-6.2.1-rhel7-x86_64.rpm
12-16
greenplum-db-6.2.1-rhel7-x86_64.rpm Pivotal Greenplum 6.2 Release Notes This document contains pertinent release information about Pivotal Greenplum Database 6.2 releases. For previous versions of the release notes for Greenplum Database, go to Pivotal Greenplum Database Documentation. For information about Greenplum Database end of life, see Pivotal Greenplum Database end of life policy. Pivotal Greenplum 6 software is available for download from the Pivotal Greenplum page on Pivotal Network. Pivotal Greenplum 6 is based on the open source Greenplum Database project code. Important: Pivotal Support does not provide support for open source versions of Greenplum Database. Only Pivotal Greenplum Database is supported by Pivotal Support. Release 6.2.1 Release Date: 2019-12-12 Pivotal Greenplum 6.2.1 is a minor release that includes new features and resolves several issues. New Features Greenplum Database 6.2.1 includes these new features: Greenplum Database supports materialized views. Materialized views are similar to views. A materialized view enables you to save a frequently used or complex query, then access the query results in a SELECT statement as if they were a table. Materialized views persist the query results in a table-like form. Materialized view data cannot be directly updated. To refresh the materialized view data, use the REFRESH MATERIALIZED VIEW command. See Creating and Managing Materialized Views. Note: Known Issues and Limitations describes a limitation of materialized view support in Greenplum 6.2.1. The gpinitsystem utility supports the --ignore-warnings option. The option controls the value returned by gpinitsystem when warnings or an error occurs. If you specify this option, gpinitsystem returns 0 if warnings occurred during system initialization, and returns a non-zero value if a fatal error occurs. If this option is not specified, gpinitsystem returns 1 if initialization completes with warnings, and returns value of 2 or greater if a fatal error occurs. PXF version 5.10.0 is included, which introduces several new and changed features and bug fixes. See PXF Version 5.10.0 below. PXF Version 5.10.0 PXF 5.10.0 includes the following new and changed features: PXF has improved its performance when reading a large number of files from HDFS or an object store. PXF bundles newer tomcat and jackson libraries. The PXF JDBC Connector now supports pushdown of OR and NOT logical filter operators when specified in a JDBC named query or in an external table query filter condition. PXF supports writing Avro-format data to Hadoop and object stores. Refer to Reading and Writing HDFS Avro Data for more information about this feature. PXF is now certified with Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports per-server user impersonation configuration. PXF supports concurrent access to multiple Kerberized Hadoop clusters. In previous releases of Greenplum Database, PXF supported accessing a single Hadoop cluster secured with Kerberos, and this Hadoop cluster must have been configured as the default PXF server. PXF introduces a new template file, pxf-site.xml, to specify the Kerberos and impersonation property settings for a Hadoop or JDBC server configuration. Refer to About Kerberos and User Impersonation Configuration (pxf-site.xml) for more information about this file. PXF now supports connecting to Hadoop with a configurable Hadoop user identity. PXF previously supported only proxy access to Hadoop via the gpadmin Greenplum user. PXF version 5.10.0 deprecates the following configuration properties. Note: These property settings continue to work. The PXF_USER_IMPERSONATION, PXF_PRINCIPAL, and PXF_KEYTAB settings in the pxf-env.sh file. You can use the pxf-site.xml file to configure Kerberos and impersonation settings for your new Hadoop server configurations. The pxf.impersonation.jdbc property setting in the jdbc-site.xml file. You can use the pxf.service.user.impersonation property to configure user impersonation for a new JDBC server configuration. Note: If you have previously configured a PXF JDBC server to access Kerberos-secured Hive, you must upgrade the server definition. See Upgrading PXF in Greenplum 6.x for more information. Changed Features Greenplum Database 6.2.1 includes these changed features: Greenplum Stream Server version 1.3.1 is included in the Greenplum distribution. Resolved Issues Pivotal Greenplum 6.2.1 is a minor release that resolves these issues: 29454 - gpstart During Greenplum Database start up, the gpstart utility did not report when a segment instance failed to start. The utility always displayed 0 skipped segment starts. This issue has been resolved. gpstart output was also enhanced to provide additional warnings and summary information about the number of skipped segments. For example: [WARNING]:-********
在Centos7上安装greenplum 6
03-21
centos7.*安装greenplum6.*的详细过程 注意： 1、仅适用于centos7，其他操作系统版本，本文档可能执行出问题 2、按照操作步骤说明，严格在master上执行或是segment上执行 3、过程中如果中断退出，继续执行是出现命令不存在，请再次执行 source /usr/local/greenplum-db/greenplum_path.sh（使环境变量生效）
Greenplum 6.8 安装配置与GPCC配置全攻略.docx
07-16
Greenplum MPP数据库6.8版本安装初始化以及gpcc监控工具安装配置全手册，初始化Greenplum。
greenplum6.7安装包
06-04
greenplum6.7安装包
6 Pivotal Greenplum 6.0 新特性介绍
murkey的专栏
04-23 991
Pivotal Greenplum 6.0 新特性介绍 Pivotal Greenplum 6.0 新特性介绍1. PGSQL版本升级2. HTAP （OLAP + OLTP）性能大幅提升3. 支持复制表（Replicated Table）4. 在线扩容（Online expand)和一致性哈希（Jump Consistent Hash）5. 磁盘配额（Disk Quota）6. 支持Zstan...
Greenplum 6 OLTP (TPC-B) 性能提升60倍
Greenplum中文社区
03-06 3884
Greenplum 6针对OLTP的使用场景完成了多项优化，极大的改进了多并发情况下简单查询、删除和更新操作的性能。这些改进包括： 合并Postgres内核版本至9.4，这些合并在带来一系列新功能的同时，也提升了系统的整体性能。例如，引入fastpath等锁优化，可以减少多并发情况下的锁竞争开销。 提供全局死锁检测，从而支持针对同一张HEAP表的并发更新/删除操作。 优化全局事务，从而减少开始事...
Greenplum 6安装指南（CentOS 7.X）
SaySyan的博客
05-27 696
一、基本概念 Greenplum是一个面向数据仓库应用的关系型数据库，因为有良好的体系结构，所以 在数据存储、高并发、高可用、线性扩展、反应速度、易用性和性价比等方面有非常 明显的优势。Greenplum是一种基于PostgreSQL的分布式数据库，其采用sharednothing架构，主机、操作系统、内存、存储都是自我控制的，不存在共享。 本质上讲Greenplum是一个关系型数据库集群，它实际上是由数个独立的数据库服务 组合成的逻辑数据库。与RAC不同，这种数据库集群采取的是MPP（Massively
Greenplum6.x搭建_安装
flying roc
07-03 1931
服务器环境配置完成后，进行安装操作。root用户登录master机器192.168.0.110将下载的greenplum-db-6.18.2-rhel7-x86_64.rpm安装包上传到/opt目录下 然后赋可执行权限 配置本地yum源（忽略） root用户登录所有服务器挂载镜像 若报错则执行如下操作由于当前虚拟机方式，这里设置共享目录，虚拟机–设置–选项–共享文件夹。每台服务器都设置 镜像文件从/mnt/hgfs/redhat7.9访问 3. 创建目录 root用户登录所有服务器 4. 安装 ...
Greenplum6安装指南
weixin_37138915的博客
07-15 1246
公司业务要更换服务器，对gp一知半解的我找了很多文档，结合了很多资料才安装成功，网上很多资料都是gp4或者更早的版本，这里记录一下gp6安装的最全步骤。 参考的一些文档：https://copyfuture.com/blogs-details/20200316122110528l3xw1wnt2cchri4 https://blog.csdn.net/u013767472/article/details/101195614#%E4%B8%89%E3%80%81%E5%AE%89%E8%A3%85Green.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值