We are excited to unveil VMware Tanzu Greenplum 7.2, the latest release designed to elevate your data analytics and AI-driven initiatives. This update introduces significant performance enhancements, advanced optimization capabilities, as well as powerful new features that collectively transform the way businesses leverage data. Here’s a closer look at what Greenplum 7.2 has to offer.
Enhanced ecosystem and improved performance
Performance Enhancements in VMware Tanzu Greenplum 7.2 include:
Index Scan on Append-Optimized (AO) Tables
Revolutionized performance. Previously disabled due to cost model constraints, index scans on AO tables are now enabled, leading to massive performance improvements for specific query patterns.
Real-World Impact. Experience up to 1000x faster query execution, with times dropping from 44,035.716 ms to just 46.615 ms!
Expanded GPORCA Use Cases
Broader optimization: GPORCA now supports parameterized queries, full hash joins, and DISTINCT-qualified window aggregates to reduce reliance on the Postgres-based Planner.
Optimized complex queries: Achieve order of magnitude performance gains and better optimization for complex query scenarios.
Greenplum optimizer hints
Targeted performance tuning. Empower DBAs and application developers with new optimizer hints, including cardinality, table access, join type, and join order hints, to refine query plans and enhance performance.
Ecosystem extensions
The latest release of VMware Tanzu Greenplum 7.2 includes ecosystem extensions such as:
pg_cron
Automated Database Management. This in-database job scheduler allows scheduling of SQL commands directly within the database, simplifying routine maintenance and data processing jobs through automation.
orafce_ext
Oracle compatibility. Enhance your database’s functionality with Oracle-compatible SQL functions for manipulating RAW data types, supporting Oracle interfaces, and the UTL_RAW module to facilitate seamless integration for Oracle users.
H3 Spatial Index support
With H3 Spatial Index support, VMware Tanzu Greenplum 7.2 enables:
Efficient Geospatial Indexing
Superior performance. The H3 hierarchical geospatial indexing system delivers exceptional performance improvements for spatial queries, outperforming traditional PostGIS solutions by reducing query execution times from ~80 seconds to ~0.7 seconds.
Versatile Use Cases
Handle complex spatial data. Efficiently manage growing volumes of geospatial data to support complex spatial relationships and interdisciplinary applications.
Faster data analysis. Enhanced geospatial query performance enables quicker data analysis and decision making.
Business value for customers
In addition to the technical enhancements in VMware Tanzu Greenplum 7.2, businesses benefit from:
Improved Performance and Efficiency
Accelerated queries. Faster query execution leads to overall system performance improvements to optimize resource usage and reduce costs.
Enhanced Functionality and Flexibility
Advanced query support. Leverage support for complex query patterns and advanced use cases, coupled with flexible database management through extensions like pg_cron and orafce_ext.
Scalability and interoperability
Seamless Data Handling. Efficiently manage large datasets and complex queries, ensuring compatibility with existing Oracle systems and various geospatial data sources.
Better user experience
Simplified Management. Automation and targeted optimization streamline database management to enhance user experience with faster and more accurate insights.
Support for modern workloads
Platform versatility. Capable of handling diverse data types and workloads, including streaming data, data federation, big data analytics, data science, generative AI, text search, and vector databases.
VMware Tanzu Greenplum 7.2 is a testament to our commitment to delivering cutting-edge data solutions that drive business success. This release empowers your organization with the unparalleled performance, advanced features, and robust ecosystem support that make it the ideal platform for your AI and analytics needs.
Upgrade to VMware Tanzu Greenplum 7.2 today and harness the power of a next generation data platform. For detailed information on the new features and how to implement them, visit our Greenplum documentation.
