Blog
How to implement TPC-H queries with GreenplumPython
A quick demonstration and examples. TPCH benchmark TPC-H is a benchmark developed to evaluate the performance of large-scale SQL and relational databases by the execution
Introduction to GreenplumPython: In-database processing of billions of rows with Python
GreenplumPython is a Python library that scales the Python data experience by building an API. It allows users to process and manipulate tables of billions of
Partition in Greenplum 7: Recursion and Inheritance
The partition hierarchy is often large and complex, and many times need hybrid table properties among different partitions. It is important to understand the recursion
Partition in Greenplum 7: What’s New
(Co-authored by Alexandra Wang) Greenplum 7 is a huge milestone for partitioned tables. Besides several improvements and fixes, this is the first Greenplum version that
HOW TO SCALE SQL SERVER
Scaling SQL Server is a common challenge many organizations face as data grows. SQL Server, a relational database management system developed by Microsoft, is widely
GP7: Clustering AO/CO tables
In addition to heap tables, starting from GPDB 7, AO/CO tables can also be clustered. Motivation CLUSTER, in general, ensures that the blocks of a
GPDB7: ALTER your table’s storage
Introduction We are introducing a capability to alter the storage characteristics of an already populated table with the ALTER TABLE command in GPDB 7. This
GPDB7: Unique indexes for AO/CO tables
Introduction Unique constraints are a classic relational database feature that ensures uniqueness of a column or a group of columns at data ingress time or
Your California Privacy Rights Cookie Settings Code of Conduct Trademark Guidelines
Terms of Use Privacy Policy Log In