Get Greenplum Started With These Resources

Introduction to Greenplum

What is Greenplum?

1.5 minutes

Greenplum Fundamentals

Marshall Presser, 15 minutes

Hello Greenplum

Bradford Boyle, 40 minutes

The Origin of Greenplum Database

Ivan Novick, Scott Yara, Luke Lonergan, 15 minutes

Greenplum Tutorial for Beginners

Ivan Novick, 100 minutes

About the Greenplum Architecture, Doc

Greenplum 5: Proven, Open-Source, Multi-Cloud Data Analytics Platform

Jacque Istok, 20 minutes

Introducing Greenplum 5

Ivan Novick, 35 minutes

Greenplum Roadmap Update 2019,

Ivan Novick, 1 hour

Data Warehousing With Greenplum,

Marshall Presser, e-Book

What is a Data Warehouse?

Scaling Postgres For Analytics

Jacque and Ivan Interview about Greenplum 1 hr

Greenplum Usage and DBA Skills

What It Means to be a Massively Parallel PostgreSQL DBA

Pravin Rao and Randy Willard, 30 minutes

About Redundancy and Failover in Greenplum Database, Doc

Starting and Stopping Greenplum Database, Doc

Greenplum psql Client

Michael Goddard, 20 minutes

Greenplum Data Definition Language

Michael Goddard, 30 minutes

Greenplum Storage Consideration

Michael Goddard, 30 minutes

Understanding Data Distribution with Pivotal Greenplum

 Dr. Venkatesh Raghavan, 12 minutes

Distribution and Skew, Doc

Greenplum Polymorphic Storage: Row and Columnar Orientation

Keaton Adams, 4 minutes

Default Storage Options

Pivotal Guru, Blog

Greenplum Table Compression: On-premises or in the Cloud

Keaton Adams, 10 minutes

Greenplum Database SQL Joins: Overview and Demo

Michael Goddard 20 minutes

Greenplum Database, mixed local data and remote hdfs data as a single table

Scott Kahler, 7 minutes

Going Beyond Structured Data with Pivotal Greenplum

Derek Comingore, Blog

Using Resource Groups

Optimizing Performance of Greenplum

Yon Lew, 1 hour

Backup and Restore Overview

Configuring Client Authentication,

Creating and Managing Databases

Creating and Managing Schemas

How to Integrate Greenplum with Hadoop, Spark, and GemFire

Kong Chan, 40 minutes

Introduction to PXF

Accessing Hadoop with PXF

Accessing Azure, Google Cloud Storage, Minio, and S3 Object Stores with PXF, Doc

Accessing an SQL Database with PXF (JDBC), Doc

Loading Data with gpload

Altered States: Greenplum Alter Table Command

Howard Goldberg, Blog


Using Indexes in Greenplum Database, Doc

About GPORCA, Doc

WITH Queries, Doc

Working with JSON data, Doc

High Concurrency, Low Latency Index Lookups with Pivotal Greenplum Database

Gianluca Rossetti, Blog

Greenplum Advanced Analytics

Machine Learning, Graph, Text, Geospatial Analytics on Greenplum

Frank McQuillan and Bharath Sitaraman, 40 minutes

Geospatial Analytics at Massive Scale

Ivan Novick, 1 hour

Introducing Pivotal Greenplum GPText 3.0

 Bharath Sitaraman, 15 minutes

Analytics for Synthetic Fraud

Bob Glithero, 10 minutes

Greenplum for Insider Threats – Lateral Movement Detection

Bob Glithero, 3 minutes

Running R Data Science Workloads in Greenplum

Woo Jung, 1 hour

Neural Networks on Greenplum with Apache MADlib

Frank McQuillan, 3 minutes

Deep Learning with Greenplum

Frank McQuillan, 35 minutes

Pivotal Greenplum PL/Container

Jack Wu, 35 minutes

The MADlib Analytics Library or MAD Skills, the SQL

Joe Hellerstein, Article

Greenplum Advanced Analytics Course, 200 slides on Graph, Geo, Python, Time Series, and Text, ppt

Github for Greenplum Advanced Analytics Course, sample queries for course above


Greenplum Deployment Considerations

So you want to build a Greenplum?

 Scott Kahler, 1 hour

Greenplum Deployment In The Wild

Jacque Istok, 1 hour

Introduction to Greenplum Building Blocks (Dell Technologies)

Jacque Istok, 10 minutes

Greenplum for Kubernetes: Bringing Cloud Databases On-Prem

Oz Basarir, 5 minutes

Pivotal Greenplum in Action on AWS, Azure, and Google Cloud Platform

Jon Roberts, 20 minutes

Greenplum on Azure Marketplace: Deployment

 Jon Roberts, 2 minutes

Greenplum on AWS Marketplace: Deployment

Jon Roberts, 4 minutes

Netezza to Greenplum: The Easiest, Quickest and Best Migration

Jacque Istok, 20 minutes

Install Greenplum OSS on Ubuntu

Ivan Novick, Web

Greenplum Internals

About Greenplum Query Processing

Understanding the internals of GPORCA Optimizer

Xin Zhang, 1 hour

Orca: A Modular Query Optimizer Architecture for Big Data

Mohamed A. Soliman, pdf

Getting Your Greenplum Environment

Cloud Marketplaces Versions

AWS Deployment


Self healing


Snapshots for HA / DR


Open Source Version

Google Cloud Platform

gpsnap create (coming soon)

Google Cloud Platform

gpsnap restore (coming soon)​

Google Cloud Platform

Azure Deployment


gpsnap create


gpsnap restore



Utilities for All Cloud Marketplaces


Utilities for All Cloud Marketplaces