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 become much simpler and more efficient. gpsupport is a powerful diagnostic utility provided by VMware Greenplum that enables

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 boasts a significant performance improvement compared to earlier releases. These resulted from several key optimizations that were implemented while

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 query refinement, resource allocation adjustments, and data safeguarding. Within this blog post, we will delve into five indispensable guidelines tailored to the effective management of Greenplum.