Greenplum Community

A Place For Greenplum Friends to Gather

  • gpsupport: Support Utility for VMware Greenplum

    Author | Nihal Jain Troubleshooting and identifying supportability issues in a complex database system can be a daunting task. However, with the advent of tools like gpsupport, the process has...

    Read More
  • Improving Greenplum Upgrade Performance

    Improving Greenplum Upgrade Performance

    Authors | Kevin Yeap & Brent Doil Introduction Greenplum Upgrade (gpupgrade) is a utility that allows in-place upgrades from Greenplum Database (GPDB) 5.x version to 6.x version. Version 1.7.0...

    Read More
  • 5 Essential Tips for Managing Greenplum Databases

    Greenplum Database is a massively parallel processing (MPP) database designed for high-performance analytics and data warehousing. Similar to handling other MPP databases, it mandates routine...

    Read More
  • 10 Examples of Compression Enablement in Greenplum

    10 Examples of Compression Enablement in Greenplum

    Author | Wen Lin Introduction Greenplum is an open-source, massively parallel data warehouse designed for analytics and AI applications. Efficient data compression is vital in Greenplum to reduce...

    Read More
  • Commonly tuned parameters in GP7

    Commonly tuned parameters in GP7

    Frequently tuned Greenplum parameters: Please find below the list of most commonly used Greenplum parameters.  Tuning these parameters can assist with the efficient memory management, performance...

    Read More
  • 20 Examples of Greenplum 7 Partition Commands

    20 Examples of Greenplum 7 Partition Commands

    Author | David Kimura Greenplum Database is a massively parallel processing (MPP) database designed for handling large-scale data warehousing and analytics workloads. One of its key features is...

    Read More
  • Parallel Restore and Partitioned Tables in GPDB

    Parallel Restore and Partitioned Tables in GPDB

    Author | Andrew Repp The release of Greenplum Database 7 (GPDB7) brings with it many new features, and each of them requires some thought to make sure we get the most out of them. Today, I want to...

    Read More
  • Big Data in Healthcare: Revolutionizing Patient Care with AI

    Big Data in Healthcare: Revolutionizing Patient Care with AI

    Big Data and AI in healthcare offer precise decision-making, personalized treatments, and efficiency enhancements. Merging structured and unstructured data provides a holistic patient view, while...

    Read More
  • Big Data in Healthcare: Revolutionizing Patient Care with AI

    Author | Joe Smith In recent years, the healthcare industry has witnessed a tremendous surge in data volume. This data originates from various sources, encompassing patient health records,...

    Read More
  • ALTER TABLE in Greenplum 7: Avoiding Table Rewrite

    ALTER TABLE in Greenplum 7: Avoiding Table Rewrite

    ALTER TABLE in Greenplum 7: Avoiding Table Rewrite The ALTER TABLE commands are commonly used for operations like adding columns, changing the column data type, and many more. In many cases, such...

    Read More
  • ALTER TABLE in Greenplum 7: Avoiding Table Rewrite

    Author | Huasong Fu The ALTER TABLE commands are commonly used for operations like adding columns, changing the column data type, and many more. In many cases, such commands require the whole...

    Read More
  • Progress reporting views in Greenplum 7

    Progress reporting views in Greenplum 7

    Authors: Alexandra Wang & Marbin Tan Progress reporting views in Greenplum 7 Greenplum 7 provides progress reporting for certain commands during their execution. The commands include ANALYZE,...

    Read More
  • Progress Reporting Views in Greenplum 7

    Authors | Alexandra Wang & Marbin Tan Greenplum 7 provides progress reporting for certain commands during their execution. The commands include ANALYZE, CLUSTER, CREATE INDEX, VACUUM, COPY and...

    Read More
  • Best Tools for Big Data Analytics

    Best Tools for Big Data Analytics

    In the increasingly digitized and data-driven business world, understanding and harnessing the power of big data is not just advantageous – it’s essential. Big data analytics tools provide the...

    Read More
  • Best Tools for Big Data Analytics

    Best Tools for Big Data Analytics

    Author | Joe Smith In the increasingly digitized and data-driven business world, understanding and harnessing the power of big data is not just advantageous – it’s essential. Big data analytics...

    Read More
  • How to Play Python3  with GPDB6

    How to Play Python3 with GPDB6

    We recently released GreenplumPython, a Python library that allows users to interact with Greenplum or PostgreSQL in a Pythonic way. GreenplumPython provides a pandas-like table API that is...

    Read More
  • Avoiding subtransaction overflow in GPDB6

    Avoiding subtransaction overflow in GPDB6

    Author | Soumyadeep Chakraborty Subtransaction overflow can really bring a cluster to it’s knees, if coupled with long running transactions. It manifests when any given backend creates more than...

    Read More
  • Accelerating Data Processing with PL/Container and GPU: A Powerful Combination

    Accelerating Data Processing with PL/Container and GPU: A Powerful Combination

    Accelerating Data Processing with PL/Container and GPU: A Powerful Combination PL/Container is an extension of the Greenplum database that provides an easy way to run user-defined functions (UDFs)...

    Read More
  • Generated Columns in Greenplum 7

    Generated Columns in Greenplum 7

    Authors: Ashwin Agrawal, Divya Bhargov, Kristine Scott Greenplum 7 brings in the STORED generated columns feature from Postgres 12. In this blog post, we’ll take a closer look at stored generated...

    Read More
  • Improving Backup Performance and Reliability with Distributed Snapshots

    Improving Backup Performance and Reliability with Distributed Snapshots

    Introduction Greenplum Database utilizes Multiversion Concurrency Control (MVCC) to maintain data consistency and manage concurrent access to data. Transaction snapshots are used to control what...

    Read More
  • loading
    Loading More...