Tagged articles
Greenplum
15 articles · Page 1 of 1
MPP (Massive Parallel Processing) databases, designed for large‑scale analytical workloads, use distributed, shared‑nothing architectures with multiple control and compute nodes, offering high scalability, diverse data‑sharding strategies, and powerful SQL compatibility, as illustrated by vendors like Teradata, Vertica, Greenplum, and emerging open‑source solutions.
Data ShardingGreenplumMPP
0 likes · 15 min read

This article explains how to simulate and diagnose segment failures in a Greenplum cluster, including identifying master, segment, and tablespace issues, generating recovery configuration files, and using gprecoverseg and gpstate commands to restore segment roles and ensure all nodes are operational.
GreenplumSegment Failuredatabase recovery
0 likes · 24 min read

This article describes how to identify and fix Greenplum standby segment failures by inspecting segment status, comparing missing files, generating a recovery configuration, executing gprecoverseg commands, and verifying that all segments return to normal operation without service interruption.
GreenplumRecoverySQL
0 likes · 17 min read

This article describes the background, architecture, and a detailed troubleshooting process for restoring a mistakenly deleted Greenplum standby data directory, including status checks, configuration cleanup, standby initialization, verification commands, and additional recommendations for handling master failures in a distributed database cluster.
Distributed DatabaseGreenplumStandby Recovery
0 likes · 10 min read

This article explains how enterprises can dramatically reduce cloud‑native data‑warehouse expenses by understanding ADB PG/Greenplum architecture, applying disk‑reservation and lock‑write safeguards, and implementing practical optimizations such as table compression, hot‑cold tiering, vacuuming, redundant‑index cleanup, replication conversion, and isolated temporary‑table spaces.
ADB PGCold DataCompression
0 likes · 25 min read

The article compares Hive and Greenplum as offline and MPP data‑warehouse solutions, reviews Hive query engine alternatives, and provides a detailed tutorial—including YAML configuration and a shell script—for using GPLoad to import HDFS data into Greenplum.
GPLoadGreenplumHive
0 likes · 8 min read

This article details the background, goals, design decisions, deployment steps, kernel tuning, fault‑recovery testing, performance optimization, and TPCH benchmark results of a Greenplum data‑warehouse cluster expansion, highlighting practical challenges and concrete solutions for large‑scale database environments.
Cluster DeploymentGreenplumLinux
0 likes · 20 min read

This article explains the fundamentals of consistent hashing, compares the classic ring‑based method with the more efficient jump consistent hash algorithm, provides reference implementations in C++, discusses their time‑complexity and practical trade‑offs, and shows how they are applied in systems such as Greenplum.
AlgorithmConsistent HashingGreenplum
0 likes · 11 min read

This article explains why Greenplum can encounter out‑of‑memory (OOM) errors, lists the typical causes, and provides detailed recommendations for memory‑related OS and database parameters, statement_mem settings, and the proper use of Greenplum resource queues to achieve stable and efficient cluster operation.
Database ConfigurationGreenplumOOM
0 likes · 13 min read

This article explains Greenplum's MPP architecture, master‑segment design, high‑availability, interconnect network, rich management tools, parallel query planning, data loading techniques, and additional capabilities such as LDAP authentication and resource queues, demonstrating why it is a strong next‑generation big‑data query engine.
GreenplumMPPParallel Query
0 likes · 15 min read

This article introduces the architecture, key modules, and implementation details of the Little Boy platform, a Greenplum optimization and operations system that parses SQL, applies index and distribution‑key tuning, manages resources, and outlines future enhancements for large‑scale data warehouses.
GreenplumSQL parsingbig data
0 likes · 15 min read

This article explains what Greenplum is, its MPP shared‑nothing architecture, and provides concrete table‑design principles, distribution‑column strategies, indexing guidance, vacuum and table‑rebuilding techniques, as well as SQL, join, insert, update/delete, and resource‑queue optimizations for better performance.
Distributed TablesGreenplumMPP
0 likes · 9 min read

This article compiles the 2016 release notes and major new features of leading relational database systems—including Oracle 12c R2, MySQL 5.7, Percona, MariaDB, SQL Server 2016 SP1, PostgreSQL 9.6, DB2 LUW 11.1, and Greenplum—highlighting enhancements in multitenancy, sharding, security, performance, and cloud integration.
DB2GreenplumMySQL
0 likes · 29 min read

Greenplum is an open‑source, massively parallel processing (MPP) database built on PostgreSQL, offering ANSI‑SQL compliance, distributed ACID transactions, linear scalability, polymorphic storage, advanced optimizers, and extensive ecosystem integrations, making it suitable for large‑scale data warehousing, analytics, and big‑data workloads.
GreenplumMPPPolymorphic Storage
0 likes · 15 min read

This article delivers a comprehensive guide to Greenplum deployment, covering early architecture planning, data‑model design, daily maintenance best practices, system‑table management, diagnostic tools like gpcheckcat, and detailed troubleshooting techniques for persistent tables and other common issues.
Data ModelingGreenplumMPP
0 likes · 13 min read
